Need help for formula…

  • Resolved ooaliceoo

    (@alicexwarehouse)


    2 years, 11 months ago

    Hello there,
    I use the calculated field and it works perfectly. I need to do a change and I am stuck again to “translate” the formula in a good way to make it work in the plugin.
    Could you please help me with this ?

    =SI(fieldname10>0;((SI(fieldname10>=60000;(fieldname10-60000)*0,01497+1643,76;SI(fieldname10>=17000;(fieldname10-17000)*0,01995+785,91;SI(fieldname10>=6500;(fieldname10-6500)*0,02993+471,64;fieldname10*0,07256)))));0)

    Thank you a lot. I am so bad at this…

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @alicexwarehouse

    Thank you very much for using our plugin. The equation would be:

    IF(fieldname10>0, IF(fieldname10>=60000, (fieldname10-60000)*0.01497+1643.76, IF(fieldname10>=17000, (fieldname10-17000)*0.01995+785.91, IF(fieldname10>=6500, (fieldname10-6500)*0.02993+471.64, fieldname10*0.07256))), 0)

    However, the use of function structure and conditional statements make the equation more readable.

    (function(){
    if(fieldname10>0)
    {
        if(fieldname10>=60000) return (fieldname10-60000)*0.01497+1643.76;        
        if(fieldname10>=17000) return (fieldname10-17000)*0.01995+785.91;        
        if(fieldname10>=6500) return (fieldname10-6500)*0.02993+471.64;        
        return fieldname10*0.07256;
    }    
    return 0;
})()

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Need help for formula…’ is closed to new replies.