Skip to Content
Former Member
Feb 05, 2009 at 04:02 PM

Variable created from multiple queries does not display in summary


I have a WEBI report with multiple queries. The results are merged and a variable is created from two measures in separate queries. The variable displays and caculates correctly when the lowest level of detail is displayed in a report. But when I create a report at a summary level the calculated variable is blank.

For example the variable displays correctly at the item level but when the report is at the brand level it does not display. I have tried using Sum but that seems to make no difference.

Any help would be appreciated.