How can I add thousand separator symbols by itself when i am using your formula?
give me an example?
-
This reply was modified 5 years, 2 months ago by
arnab28.
Hello sir,
right now I am using this formula
IF(fieldname418==0, ‘Unknown’, ‘$’+PREC(fieldname474-fieldname475,2))
how to change position – symbol when i am getting value.
right now I am getting value like $-xxxx.xx .
but I am looking for value like -$x,xxx.xx
Hello @arnab28
I’m sorry, I’ve described the logic to display the minus symbol before the currency symbol. Please, follow the instructions in the previous entries. I cannot implement your project as part of the support service. If you want me to implement your project, you should contact me through my private website: Custom Coding Service
Best regards.
Okay, I understand your point.
just one more help how to add thousand separator symbols in this previous equation.
actually, i do not find out what operator use for adding the thousand separator symbol in the calculation value.
Hello @arnab28
The plugin does not include any specific operation to include the thousand symbols. These symbols are included internally when the result is assigned to the field. So, you must implement it by yourself as part of the equation’s code.
Best regards.
For example CONCATENATE(IF(fieldname432<0,’-‘, ”), ‘$’, PREC(ABS(fieldname432),2));
this is the equation. form fieldname432 i am getting value. how can i add internally with fieldname432 value?
