dinamic condition in dimention

[#1]

Hi!

Please help if it possible.

I have expression:

=if(month = '201211',sum( TOTAL {<month={'201205'}>}Sale),0)

i need change month={'201205'} like this:

=if(month = '201211',sum( TOTAL {<month={month-6}>}Sale),0)

Is it possible to do someway?

[#2]

Hi,

You can use Addmonths() function as follows:

=if(month = '201211',sum( TOTAL {<month={AddMonths(month,-6)}>}Sale),0)

[#3]

Hi!

my "month" is not data field. it is string

[#4]

Hi!

Unfortunatly it does't work.

My field is a srting.

Please see attachment

[#5]

Hi,

Then convert string to date field using Date() and Date#() function, and use the expression stated above.

[jonathan_dau]

Hi,

Maybe you can use something like that :

sum( TOTAL {<month={">=$(=getfieldselections(month)-6)"}>}Sale)

Hope that helps

Jonathan

[MayilVahanan · Accepted solution]

HI

PFA

[#8]

Thank you vrey much!