i tried with replace(num,'k','','all') * 1000
# lucees
Simone
04/21/2022, 3:32 PMi tried with replace(num,'k','','all') * 1000
f
foundeo
04/21/2022, 3:35 PM
you might need to warp trim() around replace since you have a space after the number and before the
kfoundeo
04/21/2022, 3:37 PM
simpler solution might be:
val(num) * 1000👍 1
foundeo
04/21/2022, 3:37 PM