wildmatch from GetFieldSelections 2 conditions

[Anonymous]

hi Guys

i have the below statement i use to conditionally enable an expression in a chart and this works perfect

=Alt( WildMatch ( GetFieldSelections(%ExpressionName, '|'), '*Total Billed*' ) , 0 )

the user selects Total Billed from the %ExpressionName list box the the expression Total billed is enabled

fair enough

now my issue is :-

i want to add a second condition in the same statement like

a user enables the Total billed expression after

1. selecting the Total billed in %expressionName list box

2 .also select (for example) billing in the %ChartName ListBox

in English i would write it as

Enable Expression 'Total Billed' when 'Total Billed' is Selected in %ExpressionName and 'Billing' is selected in %ChartName

hope i make sense here

thanx in advance

[jagan · Accepted solution]

Hi,

Try like this

=WildMatch ( GetFieldSelections(%ExpressionName, '|'), '*Total Billed*' )  AND

WildMatch ( GetFieldSelections(%ChartName, '|'), '*Billing*' )

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Hi Jagan

Thanx  so far your solution seems working thank you very much i will continue testing with it because i have a number of expression