Count If

[vgadang1]

Hi,

I can't get this to work - I am trying to count the apps if the last accessed is more than 45 days. 

Count({$

<(interval(today(2)-daystart(max(LogTimeStamp)),'d') = {>"45"}>

} [App Name]) 

[BrunPierre]

Count(If(Interval(Today(2)-DayStart(LogTimeStamp, 'dd')>45,[App Name]))

or

better to derive the the days at the back end and use an expression like the below.

Count({<[Days Field] = {'>45'}>} [App Name])

[vgadang1]

@BrunPierre Count(If(Interval(Today(2)-DayStart(Max(LogTimeStamp, 'dd')>45,[App Name)) did not work, 

[Taoufiq_Zarra]

@vgadang1  mayebe

=Count({$<LogTimeStamp = {">=$(=Date(Today()-45))"}>}  [App Name])

[vgadang1]

Hi @Taoufiq_Zarra ,

Thank you, It still gives me inaccurate count, but may be I can get this to work. I am trying. 

[vgadang1]

It is counting Less than 45 days, I need the inverse but I cant get it to work 

[Taoufiq_Zarra]

        @vgadang1 

=Count({$<LogTimeStamp = {"<=$(=Date(Today()-45))"}>}  [App Name])

[vgadang1]

the output looks like this, output is completely off.

[Taoufiq_Zarra]

if not OK

can you share a sample data and the expected output