Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Sum( {< DATA_MOV = {'>=$(=AddMonths(Min(DATA_MOV), -11))'} >} TOTAL <YearMonth> ValMov)
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...
Can you post your sample data or sample apps ?
it's too big (124MB) with all data
You can do a limited data load to reduce the file size.
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.
thanks for your explanations
is there a way to get the value I needed ?