Multiple expressions in one expression ;-)

Multiple expressions in one expression ;-)

Apr 28, 2021
Henryk Ćwik wrote
Hello guys,

U dont belive how much Im glad I found this forum exist.

I have {0,50}} format as price format in csv so I'm removing { and }} with this expression:

REPLACE (REPLACE([CSV_COL(2)], '{' , ''), '}}' , '')

Result is of course 0,50.

Now I need to construct a expression which:

if the value is equal to or less than "x" will multiply this cell "x2"

if the value is greater than "x" it will multiply this cell "x1.50"

how to manage that problem?

Much thanks,
3 Answers
Avatar image
Apr 30, 2021
Support Manager agent wrote
Thanks for your post. Usually expressions are written for additional fee, but we made an exception
WHEN [CSV_COL(5)] 'x' THEN [CSV_COL(5)]*1.5

*instead of 5 use the needed CSV column, instead of x - the needed value
May 04, 2021
Henryk Ćwik wrote
Thanks for reply.

Unfortunatelly its not working properly, cause there is no ''equal or less'' solution there.

How I can contact u guys to get written for additional fee?
Avatar image
May 06, 2021
Support Manager agent wrote
Please contact us with more details of the issue at