8 Replies Latest reply: Jul 17, 2014 12:00 PM by PAUL YEO RSS

    Why Only when i select A all the row is highlighted ? But when select E 1 row not highlighted.

    PAUL YEO

      Hi All

       

       

       

       

      I start a new post for above topic because of i have found some thing new.

       

       

      I have a QV doc , when the column have zero value , the whole row will not be highlighted.

       

       

      My Existing expression is :-

       

       

      =if(Only({1}[Exec P&L Calculation])='c',Yellow())

       

       

      My Old expression is below :-

       

       

      =if([Exec P&L Calculation]='c',Yellow())

       

       

      it work fine , but when i add a new column for compute the column 1 and 2 diff , i get extra row display on the above.

       

       

      Hope some one can advise me how to remove those extra row. 

       

       

       

       

      Paul