Calculation not showing the result without editing the form again

[Mayank_Agrawal]

Hi,

I’ve got two virtual columns (Price format) - “Total Order Value” and “Payment Received” and both of them are showing the correct results individually. Now, I’m trying to get the difference of two i.e. I’m calculating “Balance Amount” (again in Price format), it’s not showing the result.

But, when I edit the form Balance Amount calculates correctly. How can I fix it or get the result realtime?

Thanks

[hru · Accepted solution]

To get the result “in real time”, you need to have the “Balance Amount” as virtual column.