Calculation on Virtual Column reverts to 0.0000 after a couple of seconds

[rommel]

Hello,

I have a virtual column that’s calculating a normalized score based on data from other virtual columns, and it shows up correctly for approximately 5 seconds before simply displaying 0.0000. It doesn’t make sense because none of the other virtual columns where that column pulls the values from change.

The virtual column that’s displaying the normalized score has the following formula:

[_THISROW].[Cases Count (Provider)]/([_THISROW].[Change Healthcare Count (Provider)]/1000)

I’ve also included screenshots of what’s happening (please refer to the bottom left panel):

Thanks in advance!

[Marc_Dillon · Accepted solution]

Try the expression without the “[_THISROW].” parts. Also change the “1000” to “1000.0”

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…

[rommel]

Fantastic - that solved it! Appreciate the help, Marc.