Set analysis only for current year ? Can it computer last 2 year from date selected ?

[paulyeo11]

Hi all

Set analysis only for current year ? Can it computer last 2 year from date selected ?

My inventory amt consist of when the date stock and amount for last 14 year start from 2000

If user select yr = 2013 mth = jan

Can QV compute since 2013 jan till 2000 jan amount ?

Paul

[kaushiknsolanki]

HI,

     Use below set analysis.

     Sum({<Date = {">=$(=monthstart(addmonths(Max(Date),-24)))<=$(=Max(Date))"}>}Amount)

Regards,

Kaushik Solanki

[paulyeo11]

    Hi SOK

    thank you for your reply.

    Sum({<Date = {">=$(=monthstart(addmonths(Max(Date),-24)))<=$(=Max(Date))"}>}Amount/1000)

  I try your expression , but i not getting the right result.

  Paul