Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this may be:
=If(Only({1} MthNbr)>=Num(month(today())), Yellow())
=If(Only({<[DP_LAG]=>} MthNbr)>=Num(month(today())), Yellow())
Try this may be:
=If(Only({1} MthNbr)>=Num(month(today())), Yellow())
=If(Only({<[DP_LAG]=>} MthNbr)>=Num(month(today())), Yellow())
Thanks very much on needed suggestion. It is working as expected.
No problem
I am glad it worked as you wanted.
Best,
Sunny