How to make a substraction with expression ?

  • 47Views
  • Last Post 24 January 2020
0
votes
Laurent Michel posted this 20 January 2020

Hi,

 

How can i make a substration on expression ?

I have turnover Year to date and turnover previous years to date on csv

I just want to have = (year to date turnover) - (previous ytod turnover)

 

Thank you

Order By: Standard | Newest | Votes
1
votes
Dmitriy Muzurov posted this 21 January 2020

Hi Laurent,

Thank you for submitting a ticket with us.

A substraction can be done with the sign of substract: "-"

So, provided, the columns are named "Year to date turnover" and "Previous YTOD turnover", the target field should be mapped with the following expression:

[Year to date turnover]-[Previous YTOD turnover]

Make sure to select DT_R8 data type on the Source Definition page for columns with numeric data:

 

We are looking forward to hearing from you, should you have any questions.

  • Supported by
  • Laurent Michel
0
votes
Laurent Michel posted this 23 January 2020

Hi,

 

I just forgot to respond thank you

0
votes
Dmitriy Muzurov posted this 24 January 2020

Dear Laurent,

You are very welcome!

Feel free to contact us back, should you require any further assistance.

Close