Calculation with field data that contains a $

[boilnh2o]

OK, I know that the better solution would be to have the data entered without a dollar sign and then use formatting... But, I've a client that insists on entering prices with dollar signs.

So when I need to do logic using the data from that field the price value ($10.00) is seen as a variable and that breaks the logic when part of the sequence is to check for empty fields.

Is there a way to "escape" out the dollar sign. I've tried the GetAsText function but that doesn't do it.

Thanks

[comment]

How about GetAsNumber()?

[Lee Smith]

Please update your profile to show which version of FileMaker, platform and OS your are currently using.

Lee