Negative Number

HCL Domino Domino Forum
1

This is probably really simple, but I’m stumped. How do I right the formula below to say:If the resulting number is negative (from temp - temp1)just enter “0”

temp := @If(FieldValue2 = “”; 0; @DbLookup(“”; ClientsReplicaID; “(Company Name and Client Code)”; FieldValue2; 24));

temp1 := @If(EmpMile = 0; 0; EmpMile);

temp - temp1

Thanks for the help!

2

Subject: Negative Number

@For(compareNum := 0; compareNum != 2147483648; compareNum := (compareNum + 1); @If( (temp - temp1) = compareNum; isPositive := @True; isPositive := @False); @If( (temp - temp1) = compareNum; compareNum := 2147483648; compareNum := compareNum))

3

Subject: Negative Number

Hi Laura,

Perhaps something like this :

@If( resultingNumber < 0 ; 0 ; …)

I am not very good in mathematics but I believe that a negative number is smaller than zero, no?

:wink:

Thierry