Hi Team,
I have 2 data columns and sample as below
| A | B |
| 216.00 | 335.80 |
| 208.30 | 156.90 |
| 0.00 | 127.60 |
| 0.00 | 0.00 |
| 0.00 | 219.00 |
| 56.26 | 79.00 |
| 0.00 | 228.00 |
| 0.00 | 0.00 |
| 0.00 | 165.10 |
| 0.00 | 72.00 |
| 0.00 | 118.00 |
| 0.00 | 77.00 |
| 0.00 | 0.00 |
| 0.00 | 172.50 |
| 0.00 | 156.00 |
I want to write a logic like below
IF !isnull([A]) THEN 'CatA'
ELSEIF !isnull([B]) THEN 'CatB'
ELSEIF !isnull([CatA]) and !isnull([CatB]) THEN 'Both'
ELSE '-'
ENDIF
But I do not see the right results considering the above formula. I want to if value only in "A" call in a new field CatA and if value only in "B" then CatB and if value in both columns then as "Both"
Thanks!
