Skip to Content
avatar image
Former Member

Incorrect results in Calculated figure

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jun 11, 2015 at 07:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 11, 2015 at 10:35 AM

    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>

    Add comment
    10|10000 characters needed characters exceeded