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 will see a couple cells that the number is greater that 20% variance from the AGREED cell right next two it. For example there are a couple cells in this screenshot that show 4 and 6. the respect Actual cell next to each is 0 so they would turn YELLOW.
We do not want to compare all the data as a collective but each row's two cells to each other (Agreed vs Actual). Can someone tell me how to make the Actual Cell turn yellow if its cell number has a greater variance of 20% vs its neighbors Agreed cell?
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.
7 Replies
- rocky09
Solution Sage
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.
- rocky09
are you trying to compare Agreed vs Actual? or variance between Agreed previous cell vs Agreed Current cell and the same with Actual?
- rocky09
do you have a date column as well?