set analysis expression

[ssriramin19]

I have a expression which is given in background color .

=IF(MthNbr>=num(month(date#(month(today()),'MMM'))),Yellow())

There is another field called DP_LAG .So my requirement is that whenever DP_LAG is selected the values above color expression should not change.

what is happening right now is that when DP_LAG is  selected color range from the above expression is not getting active. How to accommodate set analysis {<[DP_LAG]=>} in the above color expression so that when DP_LAG is selected color will not change.

Please suggest some method on this.

Thanks

Sriram

[sunny_talwar · Accepted solution]

Try this may be:

=If(Only({1} MthNbr)>=Num(month(today())), Yellow())

=If(Only({<[DP_LAG]=>} MthNbr)>=Num(month(today())), Yellow())

[ssriramin19]

Thanks very much on needed suggestion.  It is working  as expected.

[sunny_talwar]

No problem

I am glad it worked as you wanted.

Best,

Sunny