Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a single chart with columns in alternate states. I am using a formula to highlight cells in yellow when the value in the two states do not match. This formula is:
=If((Sum({[Chart 1]} Group)) <> (Sum({[Chart 2]} Group)), yellow())
This formula works great in the background color function of the expression when the value is a number. However when the value is text, it does not work. I think it has to do with it having "sum" but the expression fails when I delete it. Any idea on what I can put it in place to make the expression work for text?
May be use Only()
=If((Only({[Chart 1]} Group)) <> (Only({[Chart 2]} Group)), yellow())
May be use Only()
=If((Only({[Chart 1]} Group)) <> (Only({[Chart 2]} Group)), yellow())
That worked! Thank you very much Sunny!