greater than equal to or less than equal to in set analysis expression

[rsdhavle]

How to use greater than equal to or less than equal to in set analysis expression?

Give an example

[anbu1984 · Accepted solution]

Greater than or equal to

sum({<AMOUNT = {">=$(vMin)"}>} AMOUNT)

Lesser than or equal to

sum({<AMOUNT = {"<=$(vMax)"}>} AMOUNT)

Greater than or equal to and lesser than or equal to

sum({<AMOUNT = {">=$(vMin)<=$(vMax)"}>} AMOUNT)

count({<Date={"$(= ‘>=‘ & ‘01/01/2010’ & ‘<=‘ & ‘31/12/2012’)"}>} Dim)

[its_anandrjs]

See the below examples

For Greated then equals

=SUM({$<Date = {'>=$(=AddMonths( YearStart (Today()),-12))'}>}Sales)

For Less then equals

=SUM({$<Date = {'<=$(=AddMonths( MonthEnd (Today()),-12))'}>}Sales)

Or combination of both

=SUM({$<Date = {'>=$(=AddMonths( YearStart (Today()),-12)) <=$(=AddMonths( MonthEnd (Today()),-12))'}>}Sales)

But depends on the condition where you apply

[SunilChauhan]

sum({<Datefield={">=$(=Datefield)<=$(=Datefield)"}>}  Amount)

or  greater than or equal to

sum({<Datefield={">=$(=Datefield)"}>}  Amount)

or

less than or equal to

sum({<Datefield={"<=$(=Datefield)"}>}  Amount)

hope this helps

[Szymon]

Currently, this solution doesn't work.