Assistance with expression

[#1]

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?

[MK_QSL]

Provide sample data please along with your requirements...

[#3]

Ill put something together and attach - thanks!

[#4]

Please see attached requirement

[MK_QSL]

Still not clear... Kindly provide output you want...

[#6]

Manish I have put the requirement within the document

[stigchel · Accepted solution]

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

[#8]

Thank you for your help

[stigchel]

You're welcome