BusinessObjects Board

#computation Error

building reports desktopintelligence
#1

I am using the following formula in a variable at the Report Level

If detail =“blah” then Amt 1Else Amt 2

The report has 4 Sections as below

Section 1
Section2
Section3
Section4

when I try to do the SUM at the Section 2 it is giving computation error. But when I do the sum at the Section3 and Section 4 it works I tried all Extended syntaxes. it doesn’t work. But If I put the Amts in the respective columns without IF statements it is working.
Can you please let me is the error is because of the IF statement I am using or its something else.
Thanks

priya (BOB member since 2002-08-21)

#2

Use this approach outlined in this Reporter FAQ entry instead (summary: use a flag variabale with the WHERE clause instead of an IF…THEN…ELSE statement),

Andreas :de: (BOB member since 2002-06-20)