Forum Discussion
Calculating Variance
I have a table (see below) that we are hoping to look at the variance PER ROW CELL. Meaning.... if the ACTUAL number has a >20%, then that CELL will turn YELLOW. if you look at the table below, you...
I hope, I understood your question properly.
Try this.
create a measure:_variance = IF( AVERAGEX(data, data[Monday Agreed] - data[Monday Actual]) > 2,"#F5E633","#fff")Then, apply the conditional formatting of the column and select the measure.
are you trying to compare Agreed vs Actual? or variance between Agreed previous cell vs Agreed Current cell and the same with Actual?
im actually trying to compare Agreed previous cell vs Agreed Current cell...... like this:
the 0 would turn yellow. for each ROW that the second cell (Actual) is greater than the 20%, then it would turn yellow.
so in that table i first posted, only two cells would have turned YELLOW.