Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Developers - I have a problem
I need to be able to change the background colour if the participation rate on the week / month post the previous week / month is greater in green or red if below.
Cannot seem to get the expression right ?
Any help will be much appreciated
Using : =If( Column(0)>Column(1), LightRed(), Green()) at the moment.
Yes, using 'below' would solve your solution
well there is nthing like column(0), u start with column(1), it might help.
But still i dnt understand which columns u wish to comapre in the screenshot and where do u want green/red.
please explain.
Regards
Hey there - thanks for the response.
Sorry Typo !
I ended up using - =if(Count ([TOTAL CHARGES])>= Before( Count ([TOTAL CHARGES])), LightGreen(), LightRed())
and it worked.
I wanted to compare the next column with the previous column in the PIVOT table.
Yes, using 'below' would solve your solution