Forum Discussion

Glamour16's avatar
Glamour16
Regular Visitor
5 years ago
Solved

Substraction

Hi Guys,

 

How do I substract a column from another i.e.

Productsales 2018sales 2019substracted
x10001200200

Thank you

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Glamour16  if this helped you please mark this as "Accept as solution" so that it can help others too:-)

    Appreciate your Kudos, Press the thumbs up button!!👍

    Regards,

    Husna

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Glamour16 If you are creating calculated colum then

    subtract = Products[UnitPrice]-Products[UnitsOnOrder]
     
    Change the column names appropriate to your table name
    Appreciate your Kudos, Press the thumbs up button!!👍
    Regards,
    Husna
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Glamour16  if this helped you please mark this as "Accept as solution" so that it can help others too:-)

      Appreciate your Kudos, Press the thumbs up button!!👍

      Regards,

      Husna

  • manikumar34's avatar
    manikumar34
    Solution Sage
    5 years ago

    substract = Table[Column1]-Table[column2]

     

    Regards, 

    Manikumar