Skip to Content
0
Former Member
Jul 03, 2014 at 10:02 AM

Measure divided by Detail in a Measure Variable

122 Views

Hey Guys,

I have a measure variable in WEBI report. When i use variable in a table, i get a #Multivalue error in some of the cells.

When i saw the formula for the measure variable, it was something like this.

Variable_Name=Round(([Measure Object]/[Detail Object]);2)

I was thinking whether this formula is right logically. I think we cannot divide a Detail object or vice versa.

Please share your thoughts on this and the error also.

BOXI R3.1

SQL Server

Thanks

Shreyas