Never-mind....I just got it to work, I flipped flopped to two lines and it seems to work:
Case ( IsEmpty ( Quoted Price ) and not IsEmpty ( Date finished ) ; GetAsNumber ( JOB COSTNEW ) ;
not IsEmpty ( Date finished ) ; GetAsNumber ( Quoted Price ) )
Since I am here, does this look good? I am somewhat new at this, so I might as well double check my logic.
Sort of. What happens if Date finished is empty? What happens if there is nothing in the Quoted price? If those things never happens, then:
IsEmpty ( Quoted Price ) and not IsEmpty ( Date finished ) ; GetAsNumber ( JOB COSTNEW ) ;
GetAsNumber ( Quoted Price )
It always helps to test for all scenarios, specifically make sure fields that should never be blank are validated when entering new records so the calculations don't fail or give wrong results.
Don't see any reason to use the GetAsNumber function here. It does no harm but complicates the expression.
Thank you for the tip. I will remove the function keeping it as clean and simple as possible.