Hello @arnab28
The plugin does it by itself using its formatter. However, if you are formatting the result by yourself with custom coding, the thousands separator must be included by yourself as part of your equation. If you need a custom coding service, do not hesitate to contact me through my private website: Click Here
Best regards.
Hello sir,
Thanks for your suggestion.
But my custom coding works. I got the right result.
I am facing a problem is only thousands separator is not displayed with value.
You told me that a thousand separators must be included by yourself, can you give an example of how can I include that?
I am trying with that code
(function(){
var v= fieldname50,
v = fbuilderjQuery.fbuilder.calculator.format(v, {groupingsymbol:','});
CONCATENATE(IF(fieldname50<0,'-', ''),'$', PREC(ABS(fieldname50),2));
})()
but its not works, just help me where I kept this grouping symbol code, so it will works?
Hello @arnab28
If you use a function structure for the equation, you must include a return instruction as part of its code. Furthermore, if you want to format the value, you should do it in the operand of the concatenation that represents the number.
I’m sorry, but I cannot implement your project as part of the support. I told you this in every thread you’ve opened about this topic. If you need me to implement your equation, you must contact me through my private website.
Best regards.
Hello sir,
As you suggested i am using return as a part of custom equation.But now i am not getting “$” simbol.
please check the below code
(function(){
var v= fieldname50,
v = fbuilderjQuery.fbuilder.calculator.format(v, {groupingsymbol:’,’});
if(fieldname50) return ‘$’, PREC(ABS(fieldname50),2);
else return CONCATENATE(IF(fieldname50<0,’-‘, ”),’$’, PREC(ABS(fieldname50),2));
})()
Hello @arnab28
You can install the latest update of the plugin, and tick the checkbox: “it is a currency” in the settings of the calculated field. By ticking the checkbox, the minus symbol would be displayed in front of the currency symbol, and you would not need all the additional code you have entered into the equation.
Best regards.
-
This reply was modified 5 years, 1 month ago by
codepeople.
I can’t use the currency field because I need to show the filedname50 value in another field. that’s why I need to use this custom code. Can you help me where I mistake my custom code.
Thank you so much sir, its works as expected. It really helps me a lot. thanks
