Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
HI
PFA
Hi,
You can use Addmonths() function as follows:
=if(month = '201211',sum( TOTAL {<month={AddMonths(month,-6)}>}Sale),0)
Hi!
my "month" is not data field. it is string
Hi!
Unfortunatly it does't work.
My field is a srting.
Please see attachment
Hi,
Then convert string to date field using Date() and Date#() function, and use the expression stated above.
Hi,
Maybe you can use something like that :
sum( TOTAL {<month={">=$(=getfieldselections(month)-6)"}>}Sale)
Hope that helps
Jonathan
HI
PFA
Thank you vrey much!