Title: – sign position issue Last modified: March 30, 2021 --- # – sign position issue * Resolved [arnab28](https://wordpress.org/support/users/arnab28/) * (@arnab28) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/) * Hello, * For my calculations when I display the result negative value will show like $- XXX. but I want to show negative value like -$XXX. * is it possible to show (-) value before $? - This topic was modified 5 years, 4 months ago by [arnab28](https://wordpress.org/support/users/arnab28/). Viewing 15 replies - 1 through 15 (of 21 total) 1 [2](https://wordpress.org/support/topic/sign-position-issue/page/2/?output_format=md) [→](https://wordpress.org/support/topic/sign-position-issue/page/2/?output_format=md) * Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/) * (@codepeople) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14253408) * Hello [@arnab28](https://wordpress.org/support/users/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. * Thread Starter [arnab28](https://wordpress.org/support/users/arnab28/) * (@arnab28) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14253566) * Is it possiable all calculated field use this formula? is it possiable any jquery forula to use all calculation field only * Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/) * (@codepeople) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14253882) * Hello [@arnab28](https://wordpress.org/support/users/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. * Thread Starter [arnab28](https://wordpress.org/support/users/arnab28/) * (@arnab28) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14253909) * I have tried this formula in my calculated filed, but its not working. * Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/) * (@codepeople) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14253928) * Hello [@arnab28](https://wordpress.org/support/users/arnab28/) * You should include the equation’s code and the link to the form to check it in action. * Best regards. * Thread Starter [arnab28](https://wordpress.org/support/users/arnab28/) * (@arnab28) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14253962) * I have tried my equation in fieldname434 please see the below URL for a screenshot of this particular filed calculation ([https://ibb.co/fkxMP8D](https://ibb.co/fkxMP8D)) * there is another field where i tried your formula please see the below screenshot url ([https://ibb.co/DgwzM5z](https://ibb.co/DgwzM5z)) * Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/) * (@codepeople) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14253967) * Hello [@arnab28](https://wordpress.org/support/users/arnab28/) * My apologies there is a typo in the operation name, the correct is: `CONCATENATE` * Best regards. * Thread Starter [arnab28](https://wordpress.org/support/users/arnab28/) * (@arnab28) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14254044) * still your code is not working , please check my calculator form , see the url( [https://bsbtest.assiduusinc.com/duodenoscope](https://bsbtest.assiduusinc.com/duodenoscope)) * Please check two fileds fieldname434 and fieldname894 * Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/) * (@codepeople) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14254085) * Hello, * Please, edit your equation as follows: * ``` CONCATENATE(IF(fieldname434<0,'-', ''), '$', ABS(fieldname434)); ``` * Best regards. * Thread Starter [arnab28](https://wordpress.org/support/users/arnab28/) * (@arnab28) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14254515) * 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 * Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/) * (@codepeople) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14254540) * Hello [@arnab28](https://wordpress.org/support/users/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](https://cff.dwbooster.com/customization) * Best regards. * Thread Starter [arnab28](https://wordpress.org/support/users/arnab28/) * (@arnab28) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14255410) * 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 * Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/) * (@codepeople) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14255432) * Hello [@arnab28](https://wordpress.org/support/users/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. * Thread Starter [arnab28](https://wordpress.org/support/users/arnab28/) * (@arnab28) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14255447) * 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? * Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/) * (@codepeople) * [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/#post-14255466) * Hello [@arnab28](https://wordpress.org/support/users/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. Viewing 15 replies - 1 through 15 (of 21 total) 1 [2](https://wordpress.org/support/topic/sign-position-issue/page/2/?output_format=md) [→](https://wordpress.org/support/topic/sign-position-issue/page/2/?output_format=md) The topic ‘– sign position issue’ is closed to new replies. * ![](https://ps.w.org/calculated-fields-form/assets/icon-256x256.jpg?rev=1734377) * [Calculated Fields Form - AI Form Builder for WordPress - Contact, Payment, Quote, Quiz & More](https://wordpress.org/plugins/calculated-fields-form/) * [Frequently Asked Questions](https://wordpress.org/plugins/calculated-fields-form/#faq) * [Support Threads](https://wordpress.org/support/plugin/calculated-fields-form/) * [Active Topics](https://wordpress.org/support/plugin/calculated-fields-form/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/calculated-fields-form/unresolved/) * [Reviews](https://wordpress.org/support/plugin/calculated-fields-form/reviews/) * 21 replies * 2 participants * Last reply from: [arnab28](https://wordpress.org/support/users/arnab28/) * Last activity: [5 years, 4 months ago](https://wordpress.org/support/topic/sign-position-issue/page/2/#post-14258524) * Status: resolved