Field with ?

[LVA]

I have a repport with a calculation field. When one of the referenced fields are empty the field is filled in with a "?". What can I do in order not to have this "?" in the field ?

I have already checked the check box that says do not evaluate if all referenced fields are empty, in the calculated field and the "?" is still there.

Can someone help me please.

LVA

[DykstrL]

Can you post your calculation? You will get more definitive help.

[LVA]

Ok. The calculation - Case (Moeda = "Real"; Total Fatura / Moedas::Dollar ; Moeda = "Euro" ; (Total Fatura / Moedas::Dollar) *Moedas::Euro; Moeda = "Dolar"; Total Fatura)

Thanks, LVA

[Ender]

It could be trying to format a number that's too big for the field. Try formatting the field on the layout to show only 2 decimal places.

Or, it might be a division by zero problem (if Moedas::Dollar is empty or is zero.) You could add a case to your case statement for:

case(isempty(Moedas::Dollar) or Moedas::Dollar = 0; 0;

...

or something similar.