Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need an expression to work out the value of sales within a period.
Unit price x qty
however, I want to be able to use another field (mnthin) to determine how far I look back.
if this column is 3 - I would like to go back 3 months from today and find value. if 5 then start five months back. etc.
Could anyone help please?
Use a set expression, something like:
{<Month='$(=Date(AddMonths(Date#(Max([order_date]),'YYYYM'),-$(=mnthin)),'MMM-YY'))'>}
Where:
-Month is an field containing the months from your date
-The -$(=mnthin) will subtract the required months
-You need to change the date formats to your own
Provide sample data please along with your requirements...
Ill put something together and attach - thanks!
Please see attached requirement
Still not clear... Kindly provide output you want...
Manish I have put the requirement within the document
Use a set expression, something like:
{<Month='$(=Date(AddMonths(Date#(Max([order_date]),'YYYYM'),-$(=mnthin)),'MMM-YY'))'>}
Where:
-Month is an field containing the months from your date
-The -$(=mnthin) will subtract the required months
-You need to change the date formats to your own
Thank you for your help
You're welcome