Skip to Content
0
Oct 17, 2012 at 08:34 AM

Display -ve sign in BEx Report

32 Views

Hi Experts,

Issue

In ECC side ME23N, for particular PO number, summation of Invoice value in LC having both +ve and -ve values. Total is calculated accordingly.

Ex, for 3 invoices 10,20,-10 --> summation value is 20

In BI side, at cube I am getting correct value, but in report I am getting values as 10,20,10 --> summation value as 40.

I am not getting -ve sign in report and so when I display the total, all the values are summed up, but actual -ve values should be subtracted, this is not happening.

Please suggest me, what settings I need to check in Query to display -ve values which are there at cube level and get required output as summation value.

Thanks,

Saravanan.