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)