on 04-22-2014 12:07 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi .. what is the data type used for the keyfigure.. you have to use DEC and not FLTP.
Regards,
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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..
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.