Hi ,
can some one advice on how I can calculate two fields with a condition where both are not not negative ? as when current formula finds two negative it is giving me positive number
thanks,
e.g
GP Cost
-100 -100
200 -50
1st scenario :
formula will only count second row (sum =150)
2nd scenario :
formula to not give a positive value for row 1 , so result of sum for row one is -200 and for row 2 is 150
Thanks
Deia
You are going to have to post an example, because what you are asking for is the default behaviour.
[GP]+[Cost] will give what you want.
Or, if you need Scenario 1, use:
IIF([GP]>0 AND [Cost]>0, [GP]+[Cost],null)
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.