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
-
let myAmounts := Invoice.Amount;
let zweiteSumme := item(myAmounts, 1)(Der Zähler in der Funktion item() beginnt mit 0)
Birger
Content aside
- 6 yrs agoLast active
- 1Replies
- 1235Views