Forum Discussion

o59393's avatar
o59393
Post Prodigy
2 years ago

Calculated Column displaying duplicate values

Hi all   I have a calculated column that is repating the value per row when it should be different:           The calculated column named "W" is a multiplication of X, Y and Z. But as ...
Need Help
Show and Tell
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

o59393 Well, you have a weak many-to-many relationship between the two tables involved and that's probably a starting point for what is going wrong. 

  • o59393's avatar
    o59393
    Post Prodigy
    2 years ago

    Hi Greg_Deckler !

     

    Yes I know M:M is not recommeneded, however is the only way I can treat my model because it has multiple SKU's, which then I cluster them by categories.

     

    The source files inevitably lead me to make a M:M relationship.

     

    If you could find a turnaroud to my calculated column I would appreaciate 🙂

     

    Thanks.