cancel
Showing results for 
Search instead for 
Did you mean: 

#MultiValue Issue - Formula Issue?

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Joel_Gilbert
Employee
Employee
0 Kudos

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.