Count Function

[#1]

I want to do this function :

Count({$< EXPIRATION - [ASSET MODIFIED DATE.autoCalendar.MonthsAgo] = {">3"}>} [ASSET TITLE])

But something like the formatting is wrong because it is returning a -

I want to do a count of the asset titles in which the number in Expiration minus the number of months ago in asset modified date is greater than 3. Is there a better way to do this? Or is my formatting incorrect?

[sunny_talwar]

You are not allowed to have functions on the left hand side of the set modifier... can you try this

Count({$<[ASSET TITLE] = {"=EXPIRATION - [ASSET MODIFIED DATE.autoCalendar.MonthsAgo] >3"}>} [ASSET TITLE])

[#3]

I used a function that you previously gave me, which was,

Sum (if( Aggr( [EXPIRATION] - [ASSET MODIFIED DATE.autoCalendar.MonthsAgo] , [ASSET TITLE]  )  >= 6 , 1, 0 ))

And this has the number I want. However, now I want to have one for thse that are less than 6 but greater than 0. How?

Thank you so much

[sunny_talwar · Accepted solution]

Did my response to the other post resolves this?

[#5]

Yes, same question. Thanks again!

[sunny_talwar]

Cool, no problem