Hello All,
I have an issue that I have not come across before. I am using this formula: SUM([Related Operating Expenses][opsExpAnnualCost]) and the test is showing correctly:
But the App Viewer is showing this:
What could be causing this behavior?
Many thanks for considering my request.
Try to make a virtual column like [Expenses] that is [Related Operating Expenses][opsExpAnnualCost] and then in a different virtual column like total expenses do SUM([Expenses])
I am not sure why, but when I have had this sort of issue in the past I split it into two virtual columns and if started working.
I figured out I needed to use an action to force the field to update when changes happen on the ref table. This is solved now, at least for me.
Awesome - good to know!
