Web Intelligence Document Formulas Off

[Former Member]

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?

[Former Member]

Figured it out... The connection was limiting the number of records that could be returned (even though i was only displaying a sum)...

I wish it would let you know that...