Hi all, I have a simple problem, bu don't find the solution: I like to count not-empty fields in Collect (number of height measurements per plot, where height is not measured for all trees). I tried idm:not-blank() in the Apply when field, but still I get the number of trees (all) instead the number of height measurements. Any hint is welcome! Thanks, Lutz asked 20 Feb '18, 10:13 Fehrmann |
Hi Lutz, if I remember right, 'Apply when' does not work with functions, see answer at https://openforis.support/questions/1301/table-type-entity-how-to-check-sum-of-attributes-in-a-column This might work for entity 'tree': count(tree[idm:not-blank(tree_height)]) But if you want that 0 is regarded as missing height value, then use this count(tree[tree_height>0]) Regards, Lauri answered 24 Feb '18, 13:14 Lauri (OF) ♦♦ |