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


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!

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


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