Issue with calculation

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Issue with calculation

Viewing 3 reply threads
  • Author
    Posts
  • August 8, 2020 at 10:10 AM #41622

    Chris Ju
    Participant

    Hello,

    does anyone have same issues with calculations? Please see screenshots…

    Opening entry, the calculation field shows:

    -> 0810

    The calculation is correct after pressing CMD-R 2-3 times:

    -> 810,26 €

    But the problem keeps coming back.

    Thanks in advance
    Chris

    Attachments:
    You must be logged in to view attached files.
    August 8, 2020 at 8:12 PM #41627

    Sam Moffatt
    Participant

    Have you tried just doing the subtraction operation without the formatting to see if the output is stable there?

    One other thought is after doing the above, also set it to number as a return value and use the “Number Format” as “Currency Style”, select “Euro” for the currency and set the decimal places to two.

    August 8, 2020 at 11:40 PM #41634

    Brendan
    Keymaster

    The FORMAT() function should work as you have it there. I’m not sure why you’re seeing this behaviour. I was testing it and it seemed to be working correctly.

    Attachments:
    You must be logged in to view attached files.
    August 10, 2020 at 8:31 AM #41647

    Chris Ju
    Participant

    Thanks for your time. I changed the formula as Sam suggested and back again to my previous formula. Now it works correctly, but i don’t know why… I hope the problem won’t recur …

  • Author
    Posts
Viewing 3 reply threads

You must be logged in to reply to this topic.