-
envisionwasteAsked 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.
Page URL: https://form.jotform.com/91145688133157 -
Jed_CReplied 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_CReplied 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.
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.