how to use < and > in set analysis

[agigliotti]

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!

[MK_QSL]

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

[agigliotti]

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...

[MK_QSL]

Can you post your sample data or sample apps ?

[agigliotti]

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

[ThornOfCrowns]

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

[ToniKautto]

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.

[agigliotti]

thanks for your explanations

is there a way to get the value I needed ?