Did you try :
IF ATTR(Condition)="Expired" AND SUM(Contract cost)<>0 THEN Whatever END
I think you may need sum(Whatever) so it doesn't throw an aggregation error
Ok this worked but why? I know that's a hard question when you can see my work but I can't show you due to proprietary reasons. That said there are basic rule regarding Dimensions and Measures and getting them to play nicely with each other.
1 of 1 people found this helpful
It Worked Because You First Need To Check Aggregated Cost For Expired <>0 and Since Cost is aggregated on SUM So Dimension Should also Be aggregated by using MIN, MAX, ATTR
Thank you for helping me and putting this concept into words!