Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I need help with this table, I think it would be the function IF
state | price total | ||
A | 0 | if 'price total' = 0 and state A ( calcule 1) | |
B | 0 | if 'price total' = 0 and state B ( calcule 2) | |
C | 0 | if 'price total' = 0 and state C ( calcule 3) | |
D | 0 | if 'price total' = 0 and state D ( calcule 4) |
Hi
Try like below
if('price total' = 0 ,
pick(Match(state, 'A', 'B', 'C', 'D'), Calc1, calc2, calc3, calc4))
Hi
Try like below
if('price total' = 0 ,
pick(Match(state, 'A', 'B', 'C', 'D'), Calc1, calc2, calc3, calc4))