What can be the reason cause the row total accumulated amount wrong ?

[admin11]

Hi All,

Today i have concount a very funny issue . if you look at below table. 

1. For summary total the 5_NET_P return correct value. -190,301 ( 653-459+30-414=-190 )

2. For the Row compute accumulated amount -33-68-63=-164 , which is wrong , should 190.

Can some one share with me where go wrong ?

Remark :-

1 I have few SOURCE ,  only one of SOURCE=SG , return wrong value.

2  Below is my exprssion :-

_YTD_NP_ = [_YTD_REV_N]+[AMOUNT_TOTAL]+[_YTD_OTH_IN]

Can it be adding SUMX , will it help to return correct vaue ? 

Paul

[admin11 · Accepted solution]

Hi All

After carefully looking into expression , finally i spotted the error. 

_YTD_NP_MTH = [AMOUNT_EXP]+[AMOUNT_COGS]+[AMOUNT_REV]+[AMOUNT_OTH_IN]

After replace with above it work fine now.

PAul