Virtual Columns are causing weird mathematical errors

[djmalaka]

Hi,
In my app, I’m trying to create a data completion rate column so that I could use that nifty circular percentage thingy on Cards view to display data completion on each row.

So for this purpose, I’ve created some physical columns and virtual columns to gather data completion on each table, and finally I’ve made a virtual column of “percent” type in the parent table that basically does a very simple calculation of [Completion Count]/[Total Count] to be displayed as a percentage, but every time I save data, the percentage initially shows the correct figure, and then gets a value of ‘0’ out of nowhere once the syncing of the data completes! The [Completion Count] and [Total Count] are also virtual columns, but they retain their values. I have no idea why this is happening!

Does anyone have any idea what’s going on or what I am doing wrong?

Thanks!

[Marc_Dillon · Accepted solution]

Are you dividing an integer by a integer? Try:

1.0 * [completion] / [count]

[djmalaka]

Thank you so much @Marc_Dillon. That worked perfectly. I don’t understand why it made such a difference, but nevertheless it works perfectly!

[Steve]

Fix for expression giving 0% or missing decimal part Tips & Tricks 💡

Trying to divide two numbers to get a percentage but always getting 0? Trying to divide two numbers but losing the numbers after the decimal point? TRY THIS Convert one or both of the values in your division expression to a Decimal value, either by: (1) wrapping the value in the expression with the DECIMAL() function; (2) multiplying the value in the expression by 1.0; or (3) changing the column’s type to Decimal if suitable to the app. FOR EXAMPLE If computing a percentage from two Number co…

[Shashwat_Hemato]

Saved my day.. Thank you 😊