Change expression based on cyclic group

[#1]

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!

[jerem1234]

Try the GetCurrentField() function:

GetCurrentField(Group1)

Hope this helps!

[Anonymous]

Hi Stephen,

Try this expression : NullCount( GetCurrentField( GroupName ) )

Hope this helps,

Quentin

[jaimeaguilar]

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