If the article doesn't get you there, posting a workbook here will help us and we can find a solution that will work for you.
1 of 1 people found this helpful
There appears to be a mismatched parenthesis in your calculation. It seems you're trying to compute one ATTR() within another. Try this instead:
IF ATTR ([ProcessDate]) = ATTR([International Holiday List].[Plant_closing_date])
then [Total Orders]-[N]
else [Total Orders] end
I hope this helps,
can anyone help me in this issue?
I am unable to mix aggregate function in if condition,
If i use
Then the answer is not relevant getting 0.
Thanks in Advance,