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
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?
do you have a date column as well?