Forum Discussion

angelikamariae's avatar
angelikamariae
Helper I
6 years ago
Solved

Matrix, operations between columns

Hello I have created a column which holds the Marging as a result of the substraction of ActualSales-ActualCost column.  What you see in the picture is the values of a matrix.  If you see in bolds ...
Need Help
  • angelikamariae's avatar
    angelikamariae
    6 years ago

    ok I got it!

    I just chose "Sum" instead of min and it did what I wanted.

    thanks for your help.

     

    Angelica.

angelikamariae's avatar
angelikamariae
Helper I
6 years ago

Hi Amitchandak

the formula for the Margin column is as simple as Margin=[ActualSales-ActualCost]

 

Thanks.

 

Angelica.

angelikamariae's avatar
angelikamariae
Helper I
6 years ago

ok I got it!

I just chose "Sum" instead of min and it did what I wanted.

thanks for your help.

 

Angelica.