7 Replies Latest reply: Sep 24, 2014 11:52 AM by Andrea Gigliotti

# how to use < and > in set analysis

Hello,7

I have the expression below:

Sum( {< DATA_MOV = {'>=\$(=AddMonths(Min( TOTAL <YearMonth> DATA_MOV), -11))'} >} TOTAL ValMov)

and the dimension "YearMonth".

It seems that the Min function returns the minimum value of DATA_MOV  ignoring the <YearMonth> statement !

In the same object I added the following expression:

AddMonths(Min( TOTAL <YearMonth>  DATA_MOV), -11)

and it works as expected!

I need to use the same expression BUT inside SET ANALYSIS

Is there a special syntax that I have to use to achieve it ?

User = Password = algol

Make a clear all before!

• ###### Re: how to use < and > in set analysis

Sum( {< DATA_MOV = {'>=\$(=AddMonths(Min(DATA_MOV), -11))'} >} TOTAL <YearMonth> ValMov)

• ###### Re: how to use < and > in set analysis

No it doesn't works!

this is the scenario:

dimension values :  2014/01 , 2014/02, 2014/03, etc... (that is year/month of DATA_MOV)

ex. for the dimension value of 2014/01 I need to sum all records with DATA_MOV >= 01/02/2013

for the dimension value of 2014/02 I need to sum all records with DATA_MOV >= 01/03/2013

and so on...

• ###### Re: how to use < and > in set analysis

Can you post your sample data or sample apps ?

• ###### Re: how to use < and > in set analysis

it's too big (124MB) with all data

• ###### Re: how to use < and > in set analysis

You can do a limited data load to reduce the file size.

• ###### Re: how to use < and > in set analysis

What you want to keep in mind with dollar expansions is that they are calculated once, and as a expression total.

I would suggest that you convert your chart to a straight table, unless it already is a straight table.

Break out the dollar expanded expression and add it as a chart expression.

=AddMonths(Min( TOTAL <YearMonth> DATA_MOV), -11)

Enable the "Total Mode" called "Expression Total" for that expression.

In the total row of the table you will now see the calculated expression total, which is the value that will be expanded into your set expression.

• ###### Re: how to use < and > in set analysis

thanks for your explanations

is there a way to get the value I needed ?