Calculation not showing the result without editing the form again

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

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

2 Likes