Hide values from straight table when <1

[#1]

I have a interval calculation in my expression:

=Interval(Date([SAMPLE.Verified Date],'DD-MM-YYYY')-Date([SAMPLE.Due Date],'DD-MM-YYYY'), 'D')

This gives sometimes negative results. And i want to hide everything under the vallue 1 from the table.

How to do this?

[jonathandienst · Accepted solution]

Hi

This should do it:

=Interval(If([SAMPLE.Verified Date] > [SAMPLE.Due Date], [SAMPLE.Verified Date] - [SAMPLE.Due Date]), 'D'))

Hope that helps

Jonathan

[#3]

Thanks a lot! This seem to work.

But i forget to mentiod i have 2 expressions and i want also to hide the values from the first expression when the results from the second expression are <1.

[#4]

Hi,

Try if((Interval(If([SAMPLE.Verified Date] > [SAMPLE.Due Date], [SAMPLE.Verified Date] - [SAMPLE.Due Date]), 'D')),Expression_1)

Rebeca