When i select A Table can display amount , But select B it does not work ?

[#1]

Hi All

I have a table , when i select Bus Terminal i am able to display the COST PRICE.

But when i select the Training , it unable to display COST PRICE ?

Enclosed my QV Doc. which explan clearly my situation.

Paul

[tresesco · Accepted solution]

Your Price(Euros) , is not a numeric field.

Update: try this expression:

Num(trim([COST PRICE]))*(1-[Discount])

[#3]

Hi Tres

You very smart.

lucky  you give me the trim command , otherwise i will have to manually edit mt excel raw data file which will take up a lot of time which is very unproductive. now i can appreciate the power of trim command.

Paul