BusinessObjects Board

Reference fields in formula that are not in the layout

building reports
#1

So I made a formula that involves 2 fields in my layout.
However I want to take these fields out my layout because they are not need for the layout and they break op my summing of the line (so instead of 1 amount I get 3 amounts which some to the correct total but I want to see 1 amount)

If I remove these fields from the layout the formula throws me a #multi error.
Is there a clever way around this?

Edit:
Perhaps it makes also more sense when I add the formula.

=If [Unit of measure]=“BX” And [Prod Hier Level 2 Text - Posted] InList (“PROGLIDE” ; “STARCLOSE SE” ;
“Engage Femoral Introducer” ; “FAST CATH INTRODUCER”) Then [Billed Q] * 10

ElseIf ([Unit of measure]=“BX” And [Prod Hier Level 2 Text - Posted]=“SMALL ACCESSORIES 10PK”) Then [Billed Q]
ElseIf ([Unit of measure]=“BX”) Then [Billed Q] * 5
Else [Billed Q]

What I need is to take out the fields Units of measure and Prod Hier… But the formula then still needs to work (as it does now)

#2

Can you just put =Sum() around the whole formula?

Also, what type of object is [Billed Q]?

#3

Superb! @MarkP
I do not know why rapping it in SUM() works but it does!

Now I can take out the columns and no “multivalue” errors :slight_smile:
So instead of 27 pages I have 2 pages. Exactly what I wanted to achieve.
Thanks!

ps: Billed Q is a measure variable based on a measure from the universe which is a number and aggregate: sum.