CommaSeparate: does not work with pow math function.

  • Profile Image
    envisionwaste
    Asked on April 25, 2019 at 06: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.

  • Profile Image
    Jed_C
    Answered on April 25, 2019 at 08:16 PM

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

  • Profile Image
    Jed_C
    Answered on April 25, 2019 at 09: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

    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.