Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
the script below works for dimensions but does not work for calculated dimensions
How can i refer to the calculated dimention in the script below,,,
=if(Month(QVD_Fields)=GetFieldSelections(Month(QVD_Fields)),RGB (0,217,108),RGB(0, 164, 228))
If you look at the Current Selections, you'll see that a selection in this calculated dimension does nor produce selections in Month(QVD_FIelds), but rather the field "QVD_Fields". So your background color expression should be something like:
=if(QVD_Fields=GetFieldSelections(QVD_Fields),RGB (0,217,108),RGB(0, 164, 228))
-Rob