PDA

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