Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
I think Group 1 is the State I guess
Hahahaha may be
Concat({Group1} Len(Trim(productFamily)), '|') > 0
hi sunny t,
thanks for the reply but it isnt working
Sorry, misplaced the Len function, try this:
Len(Concat({Group1} Trim(productFamily), '|')) > 0
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.