The statement should be simple, but it's getting bounced.
The database has the cost in pennies. I would like to put out a report that has the cost in dollars and cents.
It starts out with (cost/100), but that some time comes out as 4 instead of 4.00, or 4.1 instead of 4.10.
All I should have to do is Cast ((cost/100) as Money) right?
<<<<<<<<<<<<<<<<<<<<<<<<
[LNA][Pervasive][ODBC Engine Interface]Error in expression: CAST ( ( Case_Cost / 100 ) AS MONEY )
>>>>>>>>>>>>>>>>>>>>>>>>
case_cost is < "Case_Cost" REAL, > in the schema.
The definition of cast is < CAST (exp AS type) >
I have no idea what I'm doing wrong. I'm very new at doing reports directly, rather than using a drag & drop interface.
The database has the cost in pennies. I would like to put out a report that has the cost in dollars and cents.
It starts out with (cost/100), but that some time comes out as 4 instead of 4.00, or 4.1 instead of 4.10.
All I should have to do is Cast ((cost/100) as Money) right?
<<<<<<<<<<<<<<<<<<<<<<<<
[LNA][Pervasive][ODBC Engine Interface]Error in expression: CAST ( ( Case_Cost / 100 ) AS MONEY )
>>>>>>>>>>>>>>>>>>>>>>>>
case_cost is < "Case_Cost" REAL, > in the schema.
The definition of cast is < CAST (exp AS type) >
I have no idea what I'm doing wrong. I'm very new at doing reports directly, rather than using a drag & drop interface.