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
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

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      5 years ago

      Hi, Sergiocampos 

      What is your expected result?

      Can you show the value of the column'Final ad base' [i.vendas] in the screenshot?

      In addition, please check if there is something wrong with the format of the measure i.Margin.

       

       

      Best Regards,
      Community Support Team _ Eason