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