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
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
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.
Dear Laurent,
You are very welcome!
Feel free to contact us back, should you require any further assistance.