Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to make some of the rows bold in my table. I started with one of the dimensions and clicked Text Format and entered my condition:
=if(LINETYPE='HEADER' or LINETYPE='SUM', '<B>')
But only the rows with LINETYPE=SUM shows in bold. I can't understand why this is.
Yes it is, try
=if(Match(Only( {< YEAR=, MONTH= >} LINETYPE), 'HEADER','SUM') , '<B>')
May be because of spaces
=if(Trim(LINETYPE)='HEADER' or LINETYPE='SUM', '<B>')
Still no change
Try this also
=if(Match( LINETYPE, 'HEADER','SUM') , '<B>')
Is your data (LINETYPE='HEADER') is in upper case?
Try this
=if(Index(LINETYPE,'HEADER') or LINETYPE='SUM', '<B>')
None of these seem to work. At first i thought it was because these lines have the value 0 in the expression so I created another expression which gave a value other than 0. But that didn't help.
Hi,
Can you post sample app to look over?
Regards
ASHFAQ
there's a lot of company sensitive data so I can't. I'm sorry.
If possible any sort line sample test data is Ok to find out the problem you can change names and hide any sensitive data from others.
Regards
Anand