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.