replace blank with 100%

[Chimp8471]

how can i write the following

Combi LME: ([CombiLME2_Crosstab]![PlannedTime]-[CombiLME2_Crosstab]![Combi])/[CombiLME2_Crosstab]![PlannedTime]


so that if the value of [CombiLME2_Crosstab]![Combi]

is zero then it will place 100% in the cell, it currently leaves it blank, where there is no data.

Cheers

Andy

 

[Mile-O]

When you say "zero" do you mean 0 or Null?

 

[Chimp8471]

null, i think, there is nothing in the cell

 

[Mile-O]

Combi LME: ([CombiLME2_Crosstab]![PlannedTime]-Nz([CombiLME2_Crosstab]![Combi],100))/[CombiLME2_Crosstab]![PlannedTime]

 

[Chimp8471]

thanks but it doesn't seem to put 100 in the cell, instead it gives me various figures.

 

[Chimp8471]

here is a sample of my database,

 

[Rich]

Try
Combi LME:NZ(([CombiLME2_Crosstab]![PlannedTime]-[CombiLME2_Crosstab]![Combi])/[CombiLME2_Crosstab]![PlannedTime] ,1)