Results 1 to 1 of 1

Thread: Total by PuestoTrabajo (Wrong Calculation)
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2013
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Total by PuestoTrabajo (Wrong Calculation)

    Hi, to all members of this great forum.

    Crossposted : https://chandoo.org/forum/threads/to...ulation.41915/

    The idea of ​​the table that I present in the file is to distribute a quantity of KG of production in several Puestos de Trabajo, through participations. I calculate these participations satisfactorily, both in percentage (Measure % Participación KG Real Puesto Trabajo) and in values ​​(Measure KG Real Puesto Trabajo por Mat = [Total KG Produccion IDO] * [% Participación KG Real Puesto Trabajo]).


    At the time of adding these values ​​disconnecting the material with ALL, the resulting value is wrong ... and I can not find the reason for this situation.


    Wrong measure: KG Real Totalizado Puesto Trabajo = IF(ISNUMBER([Total KG Produccion IDO]) ; CALCULATE( [KG Real Puesto Trabajo por Mat] ; ALL(fIDO[Material])) ; BLANK() )


    Could you help me calculate the correct value?


    To give examples of what you should give:


    For PuestoTrabajo 6702041, it should give: 27164.54 + 1601.96 = 28766.5 (it's giving 20266.77 <- Wrong. I do not even know where the value comes from)


    For PuestoTrabajo 6702043, it should give: 1609.11 + 10072.59 + 11160 + 764 + 3264 + 20807.55 + 4546.68 = 52223.93 (it is giving 48863.03 <- Wrong, nor do I know where the value comes from).


    and so for all the PuestosTrabajo that appear, according to the Plant filter.


    If you require more information, I will gladly supply it.


    link of file : https://mega.nz/#!hgBCQKAL!6pDDp0mbN...zmQY-4v-yWa7OQ

    Crossposted: https://chandoo.org/forum/threads/to...ulation.41915/
    I greatly appreciate the help you can give me. Blessings!
    Last edited by johnmpl; Jun 15th, 2019 at 05:42 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •