Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a straight table where I want to put a condition on 4 of the expressions to say if these month are selected then show. I am able to do it for if just one month is showing i.e (Month=1) however I want to say if Month=(1,2,3) then show.
Thanks in advance.
Hi Anna,
You can make it more simpler,
=if(GetFieldSelections(Account_Name1,',')='ABC'&','&'BCD',1,0)
Cheers,
Naresh
can i use the conditianal expression without selecting a value
from the table
Obj | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 100 | 200 | 150 | 120 | 170 | 200 | 220 | 250 | 180 | 170 | 140 | 120 | 2020 | |
2 | 110 | 210 | 160 | 110 | 160 | 210 | 230 | 260 | 170 | 150 | 130 | 130 | 2030 |
I want to display only the periods 8 to 12 and the total column (having the periods 1 to 12)
can I do it with a condition in an expression?