Skip to Content
Former Member
Jan 29, 2014 at 06:47 AM

#Multivalue on Calendar day



I have two reports – Main and Detail report:

Main report:

I have applied hyperlink on the Date column which passes Calendar day, Plant and Material to the detail report.

Now, if I select one plant and one material for a date range(1st oct till 31st oct), the hyperlink works fine. But if I select two plants, one material for date range I get #Multivalue error.

If I apply “Avoid duplicate row Aggregation” , I don’t get the #Multivalue error but now I have two rows for one date.

I don’t want to display two rows for single date. The measure values (Gallons, ($) etc) should show the summation for both the rows (1st oct) in one row .

I tried using In, ForEach and ForAll but i think i am not using the formula correctly.

Please advice.




Multivalue.jpg (43.3 kB)