Totals mistmatch

[prma7799]

Dear All,

In my expression am using if condition as below

(if(match([Group] , 'GENERAL' ,'IMPU','INSTITUTE') or match([HQ1] , 'MUMBAI','NAGPUR' , 'PATNA', 'SOUTH MUMBAI') or  WildMatch([Code], 'NP*')

,

([Sales Amount])

,

(SUM([Sales Return])

))

using this expression am getting correct values in row wise but when we check the total then we found that total is showing wrong

PFA .....

Thanks

[ecolomer]

Try with:

Sum(if(match([Group] , 'GENERAL' ,'IMPU','INSTITUTE') or match([HQ1] , 'MUMBAI','NAGPUR' , 'PATNA', 'SOUTH MUMBAI') or  WildMatch([Code], 'NP*')

,

([Sales Amount])

,

([Sales Return])

)

or

(if(match([Group] , 'GENERAL' ,'IMPU','INSTITUTE') or match([HQ1] , 'MUMBAI','NAGPUR' , 'PATNA', 'SOUTH MUMBAI') or  WildMatch([Code], 'NP*')

,

sum([Sales Amount])

,

(SUM([Sales Return])

))

[PrashantSangle · Accepted solution]

Hi,

Is this error in pivot table?

If yes then

Not sure but try with Aggr()

try like

sum(Aggr(YourEntireExpression,Dim1,Dim2))

If in Straight table then use sum of rows in Expression tab.

Kind Regards

[prma7799]

Thanks Max....

Can you tell me How to write this is in straight table...

Thanks