I created a formula which is not working and I can not understand why.
IF(Measure Var vs BP>0 && Row().style =="stylesSubtotal" || Row().style =="stylesTotal" || Row().style =="custom1","🟢",
IF(Measure Var vs BP<0 && Row().style =="stylesSubtotal" || Row().style =="stylesTotal" || Row().style =="custom1","🔴",""))
Basically, I'd like to display a green or red spot depending on the variation vs business plan, only when row style is Subtotal, Total or Custom 1.
It's working for Subtotal, but unfortunately, not for the two other row styles (green spots for Total and Custom 1 even if the variations are negative) :
For the column with the color spots, I created a new row in which I put the formula.
Hi!
I created a formula which is not working and I can not understand why.
IF(Measure Var vs BP>0 && Row().style =="stylesSubtotal" || Row().style =="stylesTotal" || Row().style =="custom1","🟢", IF(Measure Var vs BP<0 && Row().style =="stylesSubtotal" || Row().style =="stylesTotal" || Row().style =="custom1","🔴",""))
Basically, I'd like to display a green or red spot depending on the variation vs business plan, only when row style is Subtotal, Total or Custom 1.
It's working for Subtotal, but unfortunately, not for the two other row styles (green spots for Total and Custom 1 even if the variations are negative) :
For the column with the color spots, I created a new row in which I put the formula.
Thanks in advance for the help,
Alex