Allowing a dash in a price column

[jako1345]

I have a price column that is use for a supplier rate. It's INITIAL VALUE if referencing a rate sheet we have but is editable.  We have some instances that there is no freight and our customer is requiring to return a dash when it is blank. But with a Price column a dash is not allowed. here is my current formula for initial value 

ANY(
SELECT(
Rate[Rate],
AND(
[Origin] = [_THISROW].[Origin],
[Destination] = [_THISROW].[Destination],
[Supplier] = [_THISROW].[Supplier]
)
)
)

How do I add in that if my Driver column is "Customer Pickup" it will allow a dash

[Suvrutt_Gurjar]

One option is , if you do not have other calculations depending on this column, you could make the column type as text, possibly with some  valid_if constraints such as it will allow entry of only numbers and a dash.

IF( [Driver]="Pickup", 

   OR([_THIS]="-", DECIMAL([_THIS])>00.00),

DECIMAL([_THIS])>00.00

 )