Skip to Content
0
Former Member
May 01, 2009 at 03:40 PM

Web Intelligence Document Formulas Off

13 Views

I am having an issue w/ a webi document showing inaccurate formula output.

Example --- I have a formula to sum a field and subtract it from another summed field.

i.e. sum ( column a ) u2013 sum ( column b)

The report has an u201Cin listu201D filter u2013

i.e. (column z IN (u2018aaaau2019))

Output --

Group FormulaValue

aaaa 10

This works fineu2026

If we use multiple values in the in list the numbers change.

i.e. (column z IN (u2018aaaau2019,u2019bbbbu2019))

Output --

Group FormulaValue

aaaa 04

bbbb 09

Any thoughts?