Null Values

[#1]

Hi

How to show '-' values as 'NA'.

Thanks

[#2]

Thank You All

[#3]

Is it possible to apply background color for 'NA'?

[Chanty4u]

yes u can do .

if it  used in stright or pivot table

u can use custom format cell option in design grid vie.

[Chanty4u]

chk dis samples

How to dyanamically change the individual cell color os a Pivot table

Custom Format Cells in Straight Table

[jagan]

Hi,

Try like this

If(Len(Trim(DimensionName)) = 0, Color1, Color2)

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

If you handled in script like below

Hi,

Try like this

LOAD

If(Len(Trim(DimensionName)) = 0, 'NA', DimensionName) AS DimensionName

FROM ...;

If(DimensionName= 'NA', Color1, Color2)

Hope this helps you.

Regards,

Jagan.

[MayilVahanan]

Hi

Yes, its possible

Background color Expression

=if(Len(Trim(YourFieldName)>0, White(), Red())

Ex:

Project Number	Customer A/c Name	Sum([Sales Revenue])
		80449.24
1234567		21956.44
1234567	Black	13290
1234567	Jones	22576.6
1234567	Smith	22626.2