Skip to Content
Nov 10, 2012 at 05:07 PM

Formula in Webi Intelligence table filter not working



In Desktop Intelligence, the below formula works in tabel or block level filter, where as in Web Intelligence it is not working in table filter.

In Desktop Intelligence, a variable is created as

if AppRecDate>NextRevDate+1 then 1 else 0

And this variable is added to a table filter in Deski and it works.

If the same formula or variable is created in Webi and applied to table filter (format filters), it does not work and does not list of values either 1 or 0 in webi.

I would appreciate your help in this regard.