If condition

  • Resolved civilvicky

    (@civilvicky)


    4 years, 3 months ago

    fieldname1 = if the value is between 1 – 5 (0.5), if value is between 6 – 10 (0.10)

    I want insert calculated field which changes the values as per the upper field. If field1 value is between 1-5 is should use fieldname1* 0.5 formula and if fieldname1 value is between 6-10 it should use fieldname1* 0.10 formula.

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

    (@codepeople)

    4 years, 3 months ago

    Hello @civilvicky

    You don’t say anything for values values less than 1 or greater than 10. So, the equation can be implemented as follows:

    
(function(){
  var value = fieldname1;
  if(AND(1<=value, value<=5)) return value*0.5;
  if(AND(5<value, value<=10)) return value*0.1;
  return value;
})()

    Best regards.

Viewing 1 replies (of 1 total)

The topic ‘If condition’ is closed to new replies.