Incorrect results in Calculated figure

[Former Member]

Hi Experts,

I have created a analytical view.

scenario and expected results:

       VENUM   DeliveryNo   Qnty       CKF

       558          1245           20           0.4

       558          1246            30           0.6

Here needed calculated key figure is ratio 

These below are created for this scenario.

       CKF1   is      qnty with calculated before aggregation

       CKF2    is     Qnty/CKF1

But getting incorrect results:

VENUM   DeliveryNo   Qnty       CKF

       558          1245           20          1

       558          1246            30           1

very urgent, please any suggestions and comments for the sane.

Thanks.

Best Regards,

Edukondalu K

[Former Member]

In the calculation view, add an aggregate Node and select only "VENUM  " and Qnty(Add as aggregated column). This would give the "CKF1"

Next either Join or Union w.r.t VENUM, this would give "VENUM", "DeliveryNo","Qnty",Sum(qty)<group by wrt VENUM>

[Loed]

Hi,

You get this result because the value of your CKF1 is the same with your QNTY..So 20/20 = 1, same with 30/30 = 1..

VENUM   DeliveryNo        Qnty       CKF

       558          1245           20            1

       558          1246            30           1

Did you try using SUMGT or SUMCT for your CKF2?

CKF2 = QNTY / SUMGT(QNTY)

OR

CKF2 = QNTY / SUMCT(QNTY)

Regards,

Loed

[Former Member]

Hi,

Thanks for your reply. seems to be incorrect function sumgt() , sumct().

it will confirm the below pasted screen shot.