Divide and Round Up answer

[trisham777]

I have two fields, field A and field B. Field A needs to be divided by Field B and the answer needs to be rounded up. Example: 2÷5=1

How can I code this?

var AA = this.getField(“UNITSWEEK”).value;

var BB = this.getField(“MAXDAYSWK”).value;

if (BB==0) event.value = "";

else event.value = Math.ceil (AA / BB);

}

[Bernd Alheit]

Did you use the code? Any problem with this?

[trisham777]

No, I cannot get it to work yet. Have any ideas?

[Bernd Alheit]

Any error message? Where does you place the code?

[trisham777]

I changed it to this under custom calculations:

var AA = this.getField(“UNITSWEEK”).value;

var BB = this.getField(“MAXDAYSWK”).value;

event.value = "";

if(Number(BB) != 0) {

event.value = AA / BB;

event.value = Math.ceil(event.value);

}

It accepts the code, but it is not functioning.

[Bernd Alheit]

Check the field calculation order.

[trisham777]

The field calculation order is correct.

[Bernd Alheit]

I have no more idea.

[try67]

If you've used the code you posted above it will not be accepted as it contains invalid quotation marks in the first two lines, so either what you posted is not the actual code you entered, or the code you entered was not actually accepted.