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,
Rafal

3 Answers

Apr 30, 2021

Support Manager agent wrote

Thanks for your post. Usually expressions are written for additional fee, but we made an exception
CASE
WHEN [CSV_COL(5)] 'x' THEN [CSV_COL(5)]*1.5
END

*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?

May 06, 2021

Support Manager agent wrote

Please contact us with more details of the issue at contact@emagicone.com