Hi All,
I am calculating for Y/Y % but getting an error saying that Can not mix aggregate non aggregate comparison.
The calculation is:
IF [Product Controller] = [Products] THEN SUM( [Y/Y%]) Else Null END
Product Controller is a Parameter for getting product bookings.
Y/Y% : (SUM(Current YTD Booking) - SUM(Previous YTD) / SUM(Previous YTD))
Hope I will get the answer.
Regards
Good monring
the issue is here
IF [Product Controller] = attr( [Products]) THEN SUM( [Y/Y%]) Else Null END
sorry I gave you a bad answer - after reviewing I see that Y/y% is already an aggregate so the problem is first Not aggregate Y/Y% again and to aggregate the products
IF [Product Controller] = attr( [Products]) THEN ( [Y/Y%]) Else Null END
see the supersttore example attached
sorry for the confusion
I spoke on this friday at the datafamcommunityjam the recordings should be available early next week
until that time see https://jimdehner2.blogspot.com/2020/01/faq-series-cannot-mix-aggregate-and-non.html
See it your way: FAQ Series- Cannot Mix Aggregate and Non-aggregate
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
