Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Payment field having values like "$0.01M" . I want it in numeric form "0.01". What is the best way to do that ?
Thnks .
you can use substring()
if you want only numeric values try this
KeepChar('$0.01M','.0123456789')
try:
=mid(FieldName,2,len(FieldName)-1) as NewField
Hi,
May be try this..
=Num(Num#('$0.01M','$#.##M'),'#.##')
it will skip: $ sign as we are picking from 2 position
will skip M symbol as well as we are fetching till len(Field)-1
try
TextBetween(Payment field,'$','M') as Number
hiii,
you can also try numbers tab in chart properties.here you have options,you can choose the format as you want.
Regards,
Himanshi Dubey