Forum Discussion

Antonio_Gomez's avatar
Antonio_Gomez
Icon for Resolver I rankResolver I
4 years ago
Solved

Error adding Columns (Sum)

Hello Everyone,   Here I'm again with doubts and errors 😞   In the following table the "Total" column is not adding well, as you can see for example Fishing is shown 90 instead of 97 which would...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Antonio_Gomez's avatar
    Antonio_Gomez
    4 years ago

    Well v-luwang-msft amitchandak I found the solution

     

    First, I rearranged the tables. Because one table contained several merges of others and from this super table the data was being extracted.

     

    So, in this new arrangement with separable tables I applied this formula:

     

    CantBuquesTotCorr = IF(
    HASONEVALUE(PUERTOS[PortLOCODE])
    ,[CantBuquesTotales]
    ,SUMX(
    VALUES(PUERTOS[PortLOCODE])
    ,[CantBuquesTotales]
    )
    )

     

v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Antonio_Gomez ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien