CommaSeparate: does not work with pow math function.

  • envisionwaste
    Asked on April 25, 2019 at 6:27 PM

    I have a formula to calculate the Net Present value of funds.  The formula calculates the number correctly, but I cannot get the number to show if I add the seperateComa () command and a $.  But the output must show as $XXX,XXX,XXX.xx.

    If I remove the seperateComa command it sometimes shows with dollar signs.  sometimes even without the $ in the formula.  Please help or at least correct.

    Jotform Thread 1804408 Screenshot
    Page URL: https://form.jotform.com/91145688133157
  • Jed_C
    Replied on April 25, 2019 at 8:16 PM

    Please give me some time to test the condition. I'll get back to you as soon as possible.

  • Jed_C
    Replied on April 25, 2019 at 9:05 PM

    After further testing, it seems that commaSeparate doesn't work with pow().

    ex.

    I added a pow(123,3) and the total appears without the commaSeparate. Adding commaSeparate returns me with this equation instead of a value.

    1556240698The Easiest Online Form Builde Screenshot 10

    I'm not sure if this is expected or a bug so let me forward this to our L2 team for further review. 

    We'll let you know in this thread if we receive an update from them.