In my account schedule, I have a column called Variance % that is a calculated column.
There are also columns called YTD Budget and YTD Actual. Variance% is calculated based on these two.
I have a few rows that calculate ratios. They are mainly to show the ratios between the budget and the actual amount.
Can I somehow exclude Variance % in those rows?
So what I want is :
DESCRIPTION YTD BUDGET YTD ACTUAL VARIANCE%
Gross written $1383.16 $939.00 444.16
Ratio 3.04 11.00 -
As you can see I need the Variance% column to be empty when it comes to the Ratio line. Any suggestions?
They do not want to have to export to excel and make changes.