Calulating MQT using asoftable issue for latest month

[Anonymous]

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

[sushil353 · Accepted solution]

Hi,

You can try to use below expression:

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

HTH

sushil