I have a lookup column that returns the shipping method price from a relation with the shipping table depending on the shipping options / method you select.
the column values appear with currency and decimals ex. $0.00, $5.00, $10.00
I have another If-Then-Else column for Shipping Price that checks if the order is a pickup or a delivery.
If pickup then it sets value of shipping to $0.00
and if delivery it sets the value to the lookup column shipping method price BUT THE PROBLEM is the $ sign and currency format is lost.
Why does the If-then-else column return a different format than the lookupcolumn? How can i change it back to decimal with $ sign showing? any advice on what is happening in the background?