– sign position issue

  • Resolved arnab28

    (@arnab28)


    3 years, 11 months ago

    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 3 years, 11 months ago by arnab28.
Viewing 6 replies - 16 through 21 (of 21 total)
  • Thread Starter arnab28

    (@arnab28)

    How can I add thousand separator symbols by itself when i am using your formula?
    give me an example?

    • This reply was modified 3 years, 11 months ago by arnab28.
    Thread Starter arnab28

    (@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

    Plugin Author codepeople

    (@codepeople)

    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.

    Thread Starter arnab28

    (@arnab28)

    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.

    Plugin Author codepeople

    (@codepeople)

    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.

    Thread Starter arnab28

    (@arnab28)

    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?

Viewing 6 replies - 16 through 21 (of 21 total)
  • The topic ‘– sign position issue’ is closed to new replies.