Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
im trying to do a simple set analysis wich restricts the expression the past 6 months. spending a lot of googletime all i came up with is:
=count({<datLatest= {">= addmonths(Today(),-6,0)"} >} FVID)
however all i get i zero. could somone show me the correct syntax
writing
=count(if(datLatestdate_historic>addmonths(Today(),-6,0), FVID))
gets what i want, but im trying to learn the set analysis way of things
ps. using 11 SR 2
best regards
Morten
Count({<datLatest = {">=$(=Date(AddMonths(Today(),-6)))"}>}FVID)
Count({<datLatest = {">=$(=Date(AddMonths(Today(),-6)))"}>}FVID)
Thank you so much for the quick respons. It does seem to work, however i seem to be getting different results when using the two expressions:
=count(if(datLatest>addmonths(Today(),-6), FVID)) =2589 (just to show there is a difference)
and
=Count({<datLatest = {">=$(=Date(AddMonths(Today(),-6)))"} >} FVID) = 2610
Is there a difference between the two expression?
best regards
Morten
Yes there is small difference of equal sign in above expression not use and in second use may be rows not fetch in this condition please check.
=count(if(datLatest>addmonths(Today(),-6), FVID)) =2589 (just to show there is a difference)
and
=Count({<datLatest = {">=$(=Date(AddMonths(Today(),-6)))"} >} FVID) = 2610
Regards
Anand
thank you for correcting my idiotic mistake
case solved
You are Welcome
Regards
Anand