Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I would like to create an overview in the layout(preferably a table) containing all the fields in the rows and the number of empty cells as measure.
An important note: the number of empty cells should be dynamic (when adding a filter, it should change)
fictive dataset:
ID | description | Person | Measure |
---|---|---|---|
1 | table | Harry | ST |
2 | Olga | ||
3 | Screen | Eduardo |
Preferred outcome table in the lay out (but WITH dynamic :
Field | Null values |
---|---|
Description | 1 |
Person | 0 |
Measure | 2 |
Any feedback would be GREATLY appreciated
Check the attached out:
I can't find the thread, but this expression was proposed by someone else
$(=concat('if($Field=' & chr(39) & $Field & chr(39) & ',nullcount([' & $Field & '])', ',') & concat(right($Field&')',1)))