Crystal layouts (the replacement for the PLD) can use formula fields to print currency values sent from Business One like 'GBP 123.00'. What is the formula to return just the numeric part of the value?
This is an example of a formula field which makes some formatting changes to the values sent from Business One.
Shared StringVar currSymbol;
local stringvar amountstring;
if {PLD__ITEMS.F_17}='' then ' '
Else (
amountstring:=TrailCurrency ({PLD__ITEMS.F_17}, {OADM.CurOnRight}, currSymbol, {PLD__ITEMS.F_17_Symbol});
amountstring := replace(amountstring, "(", "-");
amountstring := replace(amountstring, ")", "")
)
To get the currency symbol alone, you can use PLD__ITEMS.F_17_Symbol. Is there something similar which can be used for numeric value?
Regards,
Douglas