cancel
Showing results for 
Search instead for 
Did you mean: 

Sum of Keyfigure is returning Large results

0 Kudos

hello Experts,

My DSO has keyfigure Netback value whose value  after doing aggregates on ship to and sold to become very large.

Query designer or analyzer  is returning nothing for this value.   column in analyzer for this value is coming blank. but for smaller sum values it was coming. is this possible.  Is there any maximum length restriction on sum of key figures.

Sum value is  375,954,504,000.00   .  Attcahed is screen shot.

Any help will be appreciated.

Accepted Solutions (0)

Answers (3)

Answers (3)

bmalyadri
Explorer
0 Kudos

Hi,

Since you are able to see the small sum value,try to increase the scaling factor to find out the values in analyzer.

For example , if you set a scaling factor of 1,000 then the value 3,000,000 is shown as 3,000 in analyzer.

Regards

Malyadri

former_member976
Active Contributor
0 Kudos

Hi,

No maximum length for the KF value.

your are not seeing the value for KF at analyzer.

in designer  use the number of decimal places .

select the KF -> go to display -> select the number of decimal places -0.

Thanks,

Phani.

Former Member
0 Kudos

Hi .. what is the data  type used for the keyfigure..  you have  to use DEC and not FLTP.

Regards,

Rajesh

0 Kudos

I have Used DEC Only.

Single Line Item Value is 12,972,000 but there are so many line item so adding up sum makes value   375,954,504,000.00     which is too large.  in Analyzer it is showing nothing.

I have attached screen shot also in first message where you can see how different line item make sum.

Any help..