on 04-22-2013 5:15 PM
I am working on a report, if I bring over teh year or create a split this report works great.
However I want this report not to list year.
Once I remove the year it states #Multivalue error. How do I correct this if I have the following formuls?
If[Calendar Year] = Year(CurrentDate())-1 And[Quantiy Actual]<>0 Then Sum([Revenue Actual]) Else 0
Is it the formula or is it the way I am creating the report?
I am tring to create a volume mix report that compares current year and prior year data.
As mentioned if I bring over the year it works but only for the corresponding year.
If I bring over the split it works but only for the corresponding year.
If I have a formula that compares PY and CY data is not correct.
For example:
Growth
If[Actual Revenue PYTD]<>0 Then Sum([Actual Revenue CYTD]-Actual Revenue PYTD])/[Actual Revenue PYTD]
How can I get this report to run correctly with out the error and with out bringing over the year?
Thank you.
Typically, the #MULTIVALUE message is displayed when the contents of a cell cannot be properly aggregated at the current level of projection.
Change the table properties to Avoid Duplicate Row Aggregation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.