0

Help with formula

I'm moving from a spreadsheet to Ninox, so have to translate a lot of the formulas into Ninox.

So far, with some help from Joerg, i've been able to tackle quite a few, but i've come to a formula i'm not really sure how to move over.

What i want to do could be described in the following way: if any of Field A is >= the most recent value of Field B,  then sum the values of Field C in those rows (where Field A is >= Field B).

All these fields (columns) are in the same table.

I've come up with an initial version of this, but i doubt it's right. Sticking with the A, B, C field names:

if A >= max(B) then sum(C) end

27 replies

null
    • Sean
    • 5 yrs ago
    • Reported - view

    Another thing is I don't understand your emphasis on the Date fields. You can sort, group and filter those fields if you want. Also, RST could be a data field that gets filled when Security updates.

    • Rico
    • 5 yrs ago
    • Reported - view

    Ok, Sean, thank you for your suggestions. I will look into them.

Content aside

  • 5 yrs agoLast active
  • 27Replies
  • 5130Views