truncate and tonumber togheter

[DanHD]

hi

i've a text field that i convert with the formula 'ToNumber ({MPTmpRptPrintPositionen.Menge})' now i try the truncate formula 'truncate(ToNumber {MPTmpRptPrintPositionen.Menge}))' but without any results, the field value is still 1,00.

I've tried als to round the price with the formula '
Round ({MPTmpRptPrintBelegKopf.Bruttobetrag})', here also the price still gives the value 124,00.

What can be the reason of this?

Dan

 

[lbass]

The formulas are returning the correct values--you just need to format the number for display purposes. Right click on the formula->format field->number and select -1123 as the format.

-LB

 

[DanHD]

thanks
how simple it can be ;-)

kind regards
Dan