Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi All
my QV doc
Paul
Try like this
if([Exec P&L Calculation]='c' OR [Exec P&L Calculation]=0 ,'<B>')
Failed to open the doc error
Hi Suj
You are very fast , but it does not work. can you post the QV doc file which is working ?
Paul
i have create a new post , chk it is due to my side , pls wait.
Here it is
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.
Hi Jagan
your first expression work fine , now my table look sexy. thank
Paul
Paul,
Jagan has given you the right concept.
Here is your sample and it works fine