I need some assistance with a report i am building. The report is an actuals vs budget report with a variance column. The report looks at different operations we have around the world and measures their technology spend. The goal is for the Actuals to be lower than the Budget and the variance helps us look at how much an operation is overspending or underspending.
What i need some assistnace with is a couple of things. I have a table and i need the values of the variance to indiacte red anytime there is a negative value greater than 5% of the variance value, Indicate amber if the value is equal to + - 5% of the variance and green if the value is positive and greater than 5%.
I am also running into a creative block and would greatly appreciate it if somone could give me ideas as to how else i can present this report so its easier for users to understand how much each ops is spending.
Greatly appreciate the help! 🙂
The report i have is set out like this
Slider to select year Slider to select ops - op 1 op 2 op 3 op 4......
|Op 1 ||x ||y ||y-x|
|Op 2||a||b ||-b-a|
|Op5 || || || |
|Total|| || || |