9 Replies Latest reply: Aug 21, 2014 1:43 AM by sujeet Singh

# How to high light row even when the amount is zero ?

Hi All

I have below expression which is working fine :-

=if([Exec P&L Calculation]='c','<B>')

This expression will blod the text . is working fine. As these row are summary row , i need to make the contract.

Now my issue is when on that month due to data is zero , it will not make the text bold. can some one help me adding some more script , so that even the amount is zero , it still make the text highlighted with bold.

Paul

• ###### Re: How to high light row even when the amount is zero ?

Hi All

my QV doc

Paul

• ###### Re: How to high light row even when the amount is zero ?

Failed to open the doc error

• ###### Re: How to high light row even when the amount is zero ?

i have create a new post , chk it is due to my side , pls wait.

• ###### Re: How to high light row even when the amount is zero ?

Hi Paul,

Try like this

if([Exec P&L Calculation]='c' OR Alt([Exec P&L Calculation], 0)=0 ,'<B>')

OR

if([Exec P&L Calculation]='c' OR Len(Trim(([Exec P&L Calculation]))=0 ,'<B>')

Hope it helps you.

Regards,

Jagan.

• ###### Re: How to high light row even when the amount is zero ?

Hi Jagan

your first expression work fine , now my table look sexy. thank

Paul

• ###### Re: How to high light row even when the amount is zero ?

Try like this

if([Exec P&L Calculation]='c' OR [Exec P&L Calculation]=0 ,'<B>')

• ###### Re: How to high light row even when the amount is zero ?

Hi Suj

You are very fast , but it does not work. can you post the QV doc file which is working ?

Paul

• ###### Re: How to high light row even when the amount is zero ?

Paul,

Jagan has given you the right concept.

Here is your sample and it works fine