cancel
Showing results for
Did you mean:
Not applicable

## Simple set analysis

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:

however all i get i zero. could somone show me the correct syntax

writing

gets what i want, but im trying to learn the set analysis way of things

ps. using 11 SR 2

best regards

Morten

1 Solution

Accepted Solutions
MVP

5 Replies
MVP

Not applicable
Author

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

MVP

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

Not applicable
Author

thank you for correcting my idiotic mistake

case solved

MVP

You are Welcome

Regards

Anand