Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Totals not adding up correctly for certain Purchase orders

Hello All,   This site helped me resolve a problem and I am back with another. I have data with purcahse orders that repeat as there are multiple jobs against each purchase order. The formula that ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    According to my understanding, "272830" should only appear once in the expected results. Then you can use the AVERAGE function to get the desired result.

    Below is a measure. Your 21,672,164 is because you added an extra 76,303. If I understand wrong, please explain.

    Correct value = var _table=DISTINCT(SUMMARIZE('Table',[Client PO number],[PO Fee 3-LC]))
return SUMX(_table,[PO Fee 3-LC])

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

According to my understanding, "272830" should only appear once in the expected results. Then you can use the AVERAGE function to get the desired result.

Below is a measure. Your 21,672,164 is because you added an extra 76,303. If I understand wrong, please explain.

Correct value = var _table=DISTINCT(SUMMARIZE('Table',[Client PO number],[PO Fee 3-LC]))
return SUMX(_table,[PO Fee 3-LC])

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you Stephen. This fixed the issue. You ROCK!