Forum Discussion

Sergiocampos's avatar
Sergiocampos
New Member
5 years ago

When Sum Formula goes wrong

Hello, how are you?   I have a small problem with a formula.   I have a slightly extended base on which I am performing a margin test, everything was fine until I tried the following formula:   ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

If i.cmvv and i.vendas are columns (and not measures) in the Final ad base table, then this measure should work

='Final ad base' [i.cmvv] + 'Final ad base' [i.vendas]

Hope this helps.

  • Sergiocampos's avatar
    Sergiocampos
    New Member
    5 years ago

    Hi Ashish thanks for the answer!

     

    Ok, i tried it and the result is the same, pretty strange no?

     

    Reggards

    • mahoneypat's avatar
      mahoneypat
      Microsoft Employee
      5 years ago

      Is your Fam_Item column on the same table with the columns you are SUMming?  If not, what is the relationship between them?

       

      Regards,

      Pat

       

      • Sergiocampos's avatar
        Sergiocampos
        New Member
        5 years ago

        Yes, is the same file, it's only one base.

         

        Farm_item is a classification of the items:

        CMV another column with values;

        R$ total is another column with values.

         

        i tried sumx with calculate, tried also create a new column with SUMX Farm_item, tried do just the sum and still not working.

         

        Best Reggard