Hello @arnab28
In this case you must format the output by yourself. For example, if the equation is: fieldname1+fieldname2, you should edit it as follows:
(function)(){
var r = fieldname1+fielname2;
return CONCATENTATE(IF(r<0,'-',''),'$',r);
})()
Now, the currency symbol would be managed by the equation and not the field’s settings.
Best regards.
Is it possiable all calculated field use this formula?
is it possiable any jquery forula to use all calculation field only
Hello @arnab28
You will need to process every equation by separated and process the values of calculated fields to be used in other equations.
Best regards.
I have tried this formula in my calculated filed, but its not working.
Hello @arnab28
You should include the equation’s code and the link to the form to check it in action.
Best regards.
I have tried my equation in fieldname434 please see the below URL for a screenshot of this particular filed calculation (https://ibb.co/fkxMP8D)
there is another field where i tried your formula please see the below screenshot
url (https://ibb.co/DgwzM5z)
Hello @arnab28
My apologies there is a typo in the operation name, the correct is: CONCATENATE
Best regards.
still your code is not working ,
please check my calculator form , see the url (https://bsbtest.assiduusinc.com/duodenoscope)
Please check two fileds
fieldname434 and fieldname894
Hello,
Please, edit your equation as follows:
CONCATENATE(IF(fieldname434<0,'-', ''), '$', ABS(fieldname434));
Best regards.
When i use CONCATENATE(IF(fieldname434<0,’-‘, ”), ‘$’, ABS(fieldname434)); equation i got the value but thre are two decimal value is not shown.
i am getting value is -$xxxx .
but i am looking for value like -$xxxx.xx
Hello @arnab28
You should apply the PREC operation to the last operand in the concatenation:
PREC(ABS(fieldname434),2)
I’m sorry, but the support service does not cover the customization of the plugin. If you need a custom coding service to manage your fields results in a different way, please, contact me through my private website: Custom Coding Service
Best regards.
Thnaks for your code, its working as expected. but Symbol for grouping thousands its not working when i am using your code .
for example code is CONCATENATE(IF(fieldname482<0,’-‘, ”), ‘$’, PREC(ABS(fieldname482),2));
result value is $xxxxx.xx
but i am looking for value like $x,xxx.xx
Hello @arnab28
If you are customizing the equations’ outputs, you must include the thousand separator symbols by yourself as part of the equation’s code. If you need a custom coding service, please, contact me through my private website.
Best regards.
How to add thousand separator symbols in equation code.
is the code like CONCATENATE(IF(fieldname509<0,’-‘, ‘,’), ‘$’, PREC(ABS(fieldname509),2));
or another way we can do?
Hello @arnab28
One more time, if you are modifying the format of the output to insert the negative symbol in a different position, the plugin cannot insert the thousand separator symbols by itself. So, you must edit the output to insert the symbols by yourself as part of your equation.
The support does not cover the plugin customization or the implementation of the users’ projects. If you need personalized support or a custom coding service, you should contact me through my private website.
Best regards.
