Need quick help with formatting for simple formula 4

[jayker]

I am having trouble with the following formula:
{ORDETAIL.QUANTITY ORDERED} * {INVENDSC.COST}
these are both currency fields but when I check my formula I get the following error message referring to {INVENDSC.COST}:
"A number is required here".
I'm sure it is something simple that I am missing. Please help!

 

[ForMe2]

I had this problem before. You need to change the field type. Click to show the Type conversion options under functions. (Try CCur first. If that doesn't work, then try CDbl.) If you're in Crystal Syntax your formula will look like this
{ORDETAIL.QUANTITY ORDERED} * CCur({INVENDSC.COST})

 

[synapsevampire]

Yeah, I hate Crystal's currency handling functions, something like VAL() should work but does not, there must be a better way, but try:

val(mid(totext({{INVENDSC.COST}),2))

-k

 

[lbass]

Why would quantity ordered be a currency? Try:

{ORDETAIL.QUANTITY ORDERED} * tonumber({INVENDSC.COST})

-LB

 

[synapsevampire]

Nice, *LB.

I had tried the VAL() function, which doesn't work, tonumber does...

-k