I am using webI 4.1. MY issue is , I have a report which is formula rich. The formula is showing proper value while this is with the table. This is showing correct value while used in the summary row of the table.
However, the same formula is giving wired result when I am using the same in a free floating cell.
Sometimes, this is giving #multivalue error and sometimes the value is different from the summary row. The formula is using report level context as well.
Does the formula is not getting proper data reference while used in free floating cell?
I am totally confused and the deadline is really near to me.
I have a table where detail rows are here like site id, consumption unit, reading date and deactivation date. I need to calculate the sum of unit consumption after the deactivation date where consumption>0. So my formulas are like this:
F1=if ([reading_date]>[deactivation_date]) then 1 else 0
F2=if ([Consumption_unit]>0 then 1 else 0
F3=sum([consumption_unit] IN [site_id] WHERE ((F1=1) AND (F2=1)))
Somehow this working in block level but but throwing #multiValue error or wired result for different site_id
(BOB member since 2002-08-15)