0

display the second or third or...

Accordint to this rules (at the bottom).....there's a way to display the second or the third ?

------------------------

avg(Invoice.Amount)      -- the average, ignoring empty field
cnt(Invoice.Amount)     -- the count of non-empty fields
min(Invoice.Amount)     -- the minimum value, ignoring empty fields
max(Invoice.Amount)     -- the maximum value, ignoring empty fields
first(Invoice.Amount)   -- the first value, according to Ninox' internal sorting
last(Invoice.Amount)     -- the first value, according to Ninox' internal sorting
concat(Invoice.Amount)  -- lists all values, separated by ", "

1 reply

null
    • Birger_H
    • 5 yrs ago
    • Reported - view

    let myAmounts := Invoice.Amount;
    let zweiteSumme := item(myAmounts, 1)

    (Der Zähler in der Funktion item() beginnt mit 0)

    Birger

Content aside

  • 5 yrs agoLast active
  • 1Replies
  • 1228Views