Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good evening!
I have the below dimension, that works great at outputting the desired text into the field. I should just be able to copy the same code into the Conditional Color background field, and replace the text with the color (Red(), Green()). But for some reason it's only working on some of the fields....Can anyone help me with my below code and tell me where it's wrong?
It's only coloring some of the fields, but outputting the right text
Thank you!!
-David
=
//If(Checkbox = 'Y' and No quotes are expired 'Release Checkbox' (Red)
IF([CheckBox.Price_Boolean] = 'Y' and
Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) >today(), 'Release Checkbox',
//If(Checkbox = 'Y' and quotes ARE expired, 'Update Quote' (Red),
IF([CheckBox.Price_Boolean] = 'Y' and
Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) <=today(), 'Update Quote',
//If(Checkbox = 'N' and quotes are expired then 'Check Price box in Visual' (Red)
IF(([CheckBox.Price_Boolean] = 'N' or isnull([CheckBox.Price_Boolean]) )and
Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) <=today(), 'Check Box in Visual',
//If checkbox = 'N' and no quotes are expired 'Pricing OK' (Green)
IF(([CheckBox.Price_Boolean] = 'N' or isnull([CheckBox.Price_Boolean]) ) and
Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) > today(), 'Pricing OK'))
//If(
//Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) <=today(),'Issue',
//If( Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) >today()
//and [CheckBox.Price_Boolean] = 'Y',
//'Release Checkbox',
//If( Aggr(Min([VRFQ.EXPIRATION_DATE]),[CO.CUSTOMER_ID],[COL.LINE_NO]) <today()
//and [CheckBox.Price_Boolean] = 'Y', 'Fix Material Quotes')
))