Number Fields

HCL Domino Domino Forum
1

I have looked and relooked and cannot figure out why I get a Server error: Number expected. All the fields involved with the formula are definitely number fields and I rechecked all the field names and I am stumped. I’ve tried using the + sign and @sum, nothing…Help

TotalRate := @If(TotalRate = “”; “”; TotalRate);

TotalRate_1 := @If(TotalRate_1 = “”; “”; TotalRate_1);

TotalRate_2 := @If(TotalRate_2 = “”; “”; TotalRate_2);

TotalRate_3 := @If(TotalRate_3 = “”; “”; TotalRate_3);

TotalRate_4 := @If(TotalRate_4 = “”; “”; TotalRate_4);

@Sum(TotalRate : TotalRate_1 : TotalRate_2 : TotalRate_3 : TotalRate_4));

2

Subject: Number Fields

Replace “” with 0 in the if statements.it should be

TotalRate := @If(TotalRate = “”; 0; TotalRate);

TotalRate_1 := @If(TotalRate_1 = “”; 0; TotalRate_1);

TotalRate_2 := @If(TotalRate_2 = “”; 0; TotalRate_2);

TotalRate_3 := @If(TotalRate_3 = “”; 0; TotalRate_3);

TotalRate_4 := @If(TotalRate_4 = “”; 0; TotalRate_4);

@Sum(TotalRate : TotalRate_1 : TotalRate_2 : TotalRate_3 : TotalRate_4));

Otherwise you are tring to add up a combination of numbers and strings(“”).