You could write it out explicit, the calc will execute in order
IF [Fruit] = 'Banana' AND [profit %] > 0.30 THEN 0.30
ELSEIF [Fruit] = 'Banana' AND [profit %] <-0.30 THEN -0.30
ELSEIF [Fruit] = 'Banana' THEN [profit %]
ELSEIF [profit %] > 0.35 THEN 0.35
ELSEIF [profit %] < -0.35 THEN -0.35
ELSE [profit %]
It won't work since you cannot mix non-aggregates&aggregates.
This works like a charm! Thank you
Sorry didn't realize the profit % was an aggregate
You can just modify the calc and wrap a MIN() around fruit and it will work as long as Fruit is in your vizLoD.
Fruit is a dimension. what do you mean by wrap it in a min()?
Manideep Bhattacharyya Is there a way I can have the sum of CapApplied to be 100%(=35%+30%+35%), instead of 35%?