Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from M.K.Kwok on Nov 9 at 9:43 PM Dear expert,
The Characteristic field of Capacity is a constant number which depends on the time by each records. If it uses Key Figure, it will records time double
E.g. Capacity = 100 at 06:00; 110 at 07:00; 120 at 08:00, it has 15 records at 06:00; 20 records at 07:00; 30 records at 08:00
If I use it by Key Figure, it will be 1500 at 06:00; 2200 at 07:00; 3600 at 08:00 and the total of it is 7300.
But it should be showing 100 at 06:00; 110 at 07:00; 120 at 08:00 and the total of it should be 330
Any expert can help me?
Thanks & regards,
Jack
| | | ---------------Original Message---------------
From: M.K.Kwok
Sent: Wednesday, November 09, 2016 4:33 AM
Subject: Sum the BW Characteristic Which Type is NUMC (Character String With Only Digits)
Dear Expert,
I've a BEx Query which formula of "Capacity %" in column as the following. Because of the Characteristic field of Capacity can't have the summation total. So the Capacity % also can't showing the results rows information. How can I show the summation in the columns of Capacity & Capacity %
Capacity % = Duration (Key Figures) %A Capacity (Characteristic)
Thanks & regards,
Jack |
| Reply to this email to post your response. __.____._ |   _.____.__ |
