Calulating MQT using asoftable issue for latest month

Anonymous — Wed, 10 Jan 2018 03:38:05 GMT

Hi all,

I am calculating MQT in one of my application using asoftable.

The problem is i have multiple countries where there is missing latest month sales where as some has latest month sales.

so when i am calculating the mqt sales it blindly summing up last three month sales..

I want the mqt should calculate only for those countries having latest month data.

Attached is the sample application.

Thanks is advance.

Ashish

Re: Calulating MQT using asoftable issue for latest month

sushil353 — Wed, 10 Jan 2018 04:28:50 GMT

Hi,

You can try to use below expression:

if(count({<MonthDiff={"<3"}>}MonthDiff)<3,null(), sum({<IsRolling3={1}>}Sales))

HTH

sushil