Multiple expressions in one expression ;-)

Multiple expressions in one expression ;-)

Apr 28 (5 months ago)
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
Reply
3 Answers
Avatar image
Apr 30 (5 months ago)
Nadia Bezpalko 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 (5 months ago)
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 (5 months ago)
Nadia Bezpalko agent wrote
Please contact us with more details of the issue at contact@emagicone.com