1 of 1 people found this helpful
Remove the ATTR() function from the dimension after IF and try.
Thanks for the reply... but if I remove the ATTR function then I am running into below error.
"Cannot mix Aggregate and non-aggregate comparisons or results in if expressions"
Thanks for assist Ivan, I haven't noticed that!
If I'm not wrong then I think you're trying to get the current year Net amount of "CatMan". If so then can you tell me about the field
[dtYear (d Time1)]. Is it a datetime field or just a field containing years information. If Its a date field then you should extract YEAR from that and use it in your CYDollar calculation.
CYDollar modified: IF YEAR([dtYear (d Time1)])=YEAR(Today()) THEN [Net Ext Amt] END
CatManaged: IF [Dc Cat Manage Code]="CatMan" THEN [CYDollar] END
For your information, using ATTR() will return "*" If your field contains more than one value.
Feel free to ask If you've any question.
Thank you so much Mahfooj ... that resolved my problem.
Thats a great observation ...Thanks for the help...!!
My pleasure buddy!