Yes that works, but when I want to use those fields to do another function, the logic falls apart somewhere.
Re: Caculated field "Act vs Bud"
1 of 1 people found this helpful
Is this what you want to accomplish?
You can color by Actual - Budget < 0 to calculate whether it is over budget or not. This is a table calc and needs to be computed along the Table (across).
Please let me know if you have any questions or clarify what you're hoping to achieve.
Hope this helps!
Is there a way to do this without it being a table calc? Like if I want to reference calculated fields instead?
This was wonderful. Thank you all so much for your help!
Naturally now I'm having another problem.
Including an upward arrow or downward arrow based on the result of the boolean.
I get arrows on both columns (Actual and Budget) or none at all; I can't seem to insert a new column to the right of the data that says up or down.
I want to eventually do this for more data points than what I have here - the format woule be as follows: Actual Value, Budget Value, Directional Shape; Actual Value 2, Budget Value 2, Directional Shape 2...