Skip to Content
avatar image
Former Member

#MultiValue Issue - Formula Issue?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 24, 2013 at 02:46 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded