Summarizing formulas

  • Resolved Mohsen

    (@msedighiyan86)


    2 years, 2 months ago

    Hello team
    In a calculation field I want to summarize small formulas to a constant variable
    and put it in the main formula, then the main formula will be smaller.
    Is there any way to do this?
    for example:
    i = (80.8+(((88.7-80.8)/12)*fieldname4))
    (function(){
    if(3>fieldname3)
    {
    return IF(fieldname7<=i ,”Below the 5th percentile”, the 5th percentile”); }
    })()`

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @msedighiyan86

    Thank you very much for using our plugin. You can implement an equation to cover all those operations as follows:

    
(function(){
    if(fieldname3<3)
    {
        return IF(fieldname7<=80.8+(88.7-80.8)/12*fieldname4, 'Below the 5th percentile', 'the 5th percentile'); 
    }
    return '';
})()

    Best regards.

    Thread Starter Mohsen

    (@msedighiyan86)

    Thank u so much!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Summarizing formulas’ is closed to new replies.