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:

 

i.Margin = sumx ('Final ad base', 'Final ad base' [i.cmvv] + 'Final ad base' [i.vendas])

 

the result was this:

 

 

Clearly the result should not be this, could someone help me fix and explain what went wrong with the formula?

 

Best Regards

 

 

 

 

Need Help

5 Replies

  • 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