Filter in straight table

[#1]

We created  straight table  .We need to use filter : datefield<Today and sum(opensumfield)>0.  The  condition we created doesnt work properly: If(datefield<Today(),1,0)and If(opensumfield>0,1,0). We get also -1 values. What is wrong with it?

[tresesco]

May be like :

=If(datefield<today() AND opensumfield>0 , 1,0)

[#3]

And if I want to use this condition so that the chart will show only those records, which fulfill the condition? How to do this?

[MayilVahanan]

HI

May be try like this

= Sum({<Datefield = {"<$(=today())"}, UniqueId = {"=Sum(opensumfield) > 0"}>}opensumfield)

or

= Sum({<Datefield = {"<$(=today())"}, opensumfield= {"> 0"}>}opensumfield)

[tresesco]

Then use calculated dimension with expression : =If(datefield<today() AND opensumfield>0 , datefield)

and then check 'Suppress When Value Is Null' in the dimension tab.

Then only the valid dates will be displayed in the dimension column.