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

27replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Sean
    • Sean
    • 3 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.

    Like
    • Rico
    • Rico
    • 3 yrs ago
    • Reported - view

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

    Like
Like Follow
  • 3 yrs agoLast active
  • 27Replies
  • 5031Views