February 18, 200521 yr 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
February 18, 200521 yr Author Ok. The calculation - Case (Moeda = "Real"; Total Fatura / Moedas::Dollar ; Moeda = "Euro" ; (Total Fatura / Moedas::Dollar) *Moedas::Euro; Moeda = "Dolar"; Total Fatura) Thanks, LVA
February 18, 200521 yr 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.
Create an account or sign in to comment