condition on field in group alternate state

[idogridish]

hello everyone.

i am trying to have a condition on a table in the layout where productFamily of Group1 in alternate state is not null.

not isnull(([Group1]<>)productFamily )

something like that.

thanks in advance.

[sunny_talwar]

Group1 is a cycle/drilldrown group or a field in your application? If it is a field, try this:

Concat({AlternateStateName} Len(Trim(Group1)), '|') > 0

[Kushal_Chawda]

I think Group 1 is the State I guess

[sunny_talwar]

Hahahaha may be

Concat({Group1} Len(Trim(productFamily)), '|') > 0

[idogridish]

hi sunny t,

thanks for the reply but it isnt working

[sunny_talwar]

Sorry, misplaced the Len function, try this:

Len(Concat({Group1} Trim(productFamily), '|')) > 0

[idogridish]

thanks i found the answer.

= only({[Group 1]}not isnull(ProductName))=-1 for one group.

for more groups

= only({[Group 1]}{[Group 2]}{[Group 3]}not isnull(ProductName))=-1

thanks.