I wanted to provide a conditional formatting to entire row, the field i am cheking for the conditional formatting is not needed in my table, so i made it optional metric and hid from the primary table, then i gave two formatting conditions, one works and other works only if i enable the optional metric in the table. why is it so?
2nd rule which is not working is below:
