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.