Summing issue

[former_member203627]

Hi,

I have a field amount which needs to be summarised based on couple of fields(primary keys).

When I am using sum function which is working finr for some cases but for some records it is giving 2 cent difference.

Like if I do sum in excel sheet I get 3000 where as in X m getting 2998.

Can anyone please suggest what can be done.

We have SP 18 level ! ! !

Regards

Hema

[former_member203627]

Answered

[sunilchandra007]

>

> Hi,
> 
> I have a field amount which needs to be summarised based on couple of fields(primary keys).
> When I am using sum function which is working finr for some cases but for some records it is giving 2 cent difference.
> 
> Like if I do sum in excel sheet I get 3000 where as in X m getting 2998.
> 
> Can anyone please suggest what can be done.
> 
> We have SP 18 level ! ! ! 
> 
> Regards
> Hema

Hi,

These type of error were seen before SP 18. I think this was fixed in SP18.

But still you are getting error. The only solution left is - UDF.

Also have a look at sap note : 958486

https://service.sap.com/sap/support/notes/958486

Regards,

Chandra

[Former Member]

Hi,

This is not because of sum functionality issue.Check in your mapping before using sum function is there any other function like round kind of thing you are using.Also check the context of the source field of sum function. Is there all the values are in the queue.

Regards,

Prakasu.M

[Former Member]

Hey

Please check the below blog

/people/thorsten.nordholmsbirk/blog/2006/08/25/new-arithmetic-and-statistical-functions-in-message-mappings-in-sp18

Thanks

Aamir