0

Anyone know how to replicate a SumProduct() function in Ninox?

I have a Google Sheet that calculates Net to Gross income based on local income tax brackets with the help of SumProduct() functions. So far I have always used it and then went back to our salary database to input the figures but I was wondering if I could move that into Ninox to have everything under the same roof. As I'm new to Ninox, I'm not able to see how easy or difficult this would be to setup. As far as I can tell there is no SumProduct() function in Ninox but maybe some array + sum combination could do the same.

Has anyone done something similar in Ninox? 

2 replies

null
    • Jorg
    • 5 yrs ago
    • Reported - view

    Hi Halio, 

    In Ninox there is a sum() function that can sum up a field of all records that meet a certain condition, e.g.:

     

    sum(select myTable where fieldvalue > 7)

     

    Kind regards, Jörg

    • Halio
    • Halio
    • 5 yrs ago
    • Reported - view

    Thanks Jörg, That did the trick in a different place where I needed it. I'll check back if I get it to work for the reverse tax calculator.

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 974Views