Skip to Content

Sales Order Total KF calculation not working

Hello Team,

I am unable to see the below KF working in excel planning view. its a simple total of the below three KF:

order-total.jpg (69.7 kB)
total-order-kf.jpg (72.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Oct 25, 2019 at 04:47 AM

    Hi Rahul,

    You've marked key figure type as "Stored" but using it to calculate sum of three key figures. You should mark the target key figure as "Calculated". Also, in the calculation defined at MTHPRODLOCCUSTUOMTO, UOMCONVERSIONFACTOR is correctly marked as stored input but Total Open Sales Order is also marked as stored. Remove the stored input for this key figure from this calculation. Post which, the small cube besides open sales order will disappear. You can also refer to the key figure calculation tree to validate if the key figure has been correctly setup and will populate values as intended.

    Regards,

    Piyush


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 24, 2019 at 02:39 PM

    Hello Rahul

    Request = UOMTO

    do UOM convertion

    UOMTO = Total sales * UPM conversion

    then add

    Total sales = sum of 3 KF

    this should work . UOM conversion is missing

    ensure master data has UOM conversion master data maintained

    Anil

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 24, 2019 at 06:20 PM

    Hi Rahul

    Yes I see calculation

    Did you maintained master data for UOM conversion for base and UOMTO for your product and then mention in planning view Key figure tab as UOMTO

    PRODUCT UOMTO conversion factor ….

    if this is not done then we don't see result

    This might fix the issue

    Anil

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.