I have a list with 3 main columns, [Budget], [Balance], and [Savings - Deficit]. [Savings - Deficit] is using the floor() function to round down to the dollar. So it looks like this: floor([Budget]-[Balance]).
My problem is that when I summarize in groups and list, the summary for [Savings - Deficit] is totaling the raw values for [Budget]-[Balance], then applying the floor() function to that amount instead of totaling the already rounded values. I'm sure this is an easy fix, but I've tried a lot and haven't seen anything online quite like it. Most reference crosstabs and solve order.
I have [Savings - Deficit] aggregation set to calculated as well as Total(Savings - Deficit). I have tried mixtures of total and calculated, but can't get anything that looks right.
Thanks in advance for any help.