0

Negative Round number make the APP CRASH!!!

I started using Ninox a few years ago. In some cases, I need to round with a negative value. For example, rounding the number 1,234,567.78 with (-2) should return 1,234,500.00. That’s how I used to do it in Excel, and it was also working perfectly in Ninox.

However, after the latest major update, many of my databases crashed. At first, I didn’t understand the reason, and it took me a long time to figure it out. I honestly thought I had lost everything. I tried to contact the Ninox team to downgrade the app, but that wasn’t possible. I submitted several support requests and update comments, but received no response.

After many days of troubleshooting, I managed to adjust the formula so that if the rounding value is less than 0, it defaults to 0. That temporarily solved the issue. But recently, I accidentally entered a negative rounding number again, and my database crashed once more. Now I can’t even open the app.

Does anyone know how to fix this issue or how to properly contact support to resolve this logic problem, so I can recover my database and continue my work?

1 reply

null
    • John_Halls
    • 5 hrs ago
    • Reported - view

    You are right! I've quickly put together a global function to address this. I've kept it line by line so you can see how it works

    function rnd(numberToRound : number,digits : number) do
    if digits >= 0 then
        round(numberToRound, digits)
    else
        let a := abs(digits);
        let b := pow(10, a);
        let c := numberToRound / b;
        let d := round(c, 0);
        let e := d * b;
        e
    end
end

     Regards John

Login to reply

Content aside

  • 5 hrs agoLast active
  • 1Replies
  • 18Views
  • 2 Following