Variables

Hi,

Pay attention to your equation, the first line of code:

var upa = FLOOR(fieldname46/upb);

uses the upb variable that has not been defined yet, so you should swap both lines of code.

The line of code: var upg = IF(upe==1,-upf,0); should use the mathematical operation: var upg = IF(upe==1,-1*upf,0);

So, the equation would be:

(function(){
var upb = fieldname54+15;
var upa = FLOOR(fieldname46/upb);
var upc = upa*upb;
var upd = fieldname46-upc;
var upe = upd/15;
var upf = IF(upe>1,upa,upa-1);
var upg = IF(upe==1,-1*upf,0);
var uph = IF(upe==1,upa,0);

return upf+upg+uph;

})()

Best regards.

You pro!