Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Is there possibly a way for the user to choose what field to investigate in the expression (for my purposes in a pivot table)?
For example, I have a cyclic group with fields, say field1, field2, field3.
In the pivot table, I want to display the null count for each field as I cycle through, but if I make the expression NullCount(field1), I would have to go back into the expressions box and change the inside of the NullCount(____) to field2 or field3 whenever I want to look at the different null counts.
Is there a way to make the expression read something like NullCount(group), where the group cycles through the corresponding fields?
Thanks for the help!
Try the GetCurrentField() function:
GetCurrentField(Group1)
Hope this helps!
Hi Stephen,
Try this expression : NullCount( GetCurrentField( GroupName ) )
Hope this helps,
Quentin
Hi,
just to mention when you refer to the Group Name as in GetCurrentField(Group1) or NullCount( GetCurrentField( GroupName ) ), the group name will be underlined as if it was a mistake but is just a bug with syntax highlighting, so it should work,
regards