View Full Version : Mergeformat set decimal separator
KilpAr
09-21-2017, 05:16 AM
Current field code: {DOCPROPERTY "..." \# 0,00}
Current display: 600.00
Wanted display: 600,00
Needed field code?
macropod
09-21-2017, 05:37 PM
Is there a reason you can't simply insert the data - in the required format - into the document property? That way, you wouldn't need any switches or, in this case, complex field coding to alter the output.
KilpAr
09-22-2017, 02:14 AM
Is there a reason you can't simply insert the data - in the required format - into the document property? That way, you wouldn't need any switches or, in this case, complex field coding to alter the output.
Yes, it comes from external system as a property which I can use thru fields. I need to check whether I can manipulate it there.
macropod
09-22-2017, 02:44 PM
In that case you might try a field coded like:
{QUOTE{SET Val {DOCPROPERTY MyNum}}"{IF{=INT(Val) \# 0}< 1000 {=INT(Val) \# 0} {IF{=INT(Val) \# 0}< 1000000 {=INT(Val) \# "0'.'000"} {=INT(Val) \# "0'.'000'.'000"}}},{=(Val-INT(Val))*100 \# 00}"}
This will accommodate values up to 999,999,999.99
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.