1 Reply Latest reply: Nov 11, 2016 10:14 AM by Clever Anjos RSS

    Help with expression >=1

    Marius August Larsen

      Hi,

       

      I want my expression to show 1, when the value is >=1.

       

      =((sum(k_faktor) * sum(GDTNORM) / sum(aggr(if(avg(kWhTemp) >=17, 0, 17-avg(kWhTemp)), Dato))) + ('1'-sum(k_faktor)))

       

      feks:

      when the result is 0,96 = okay. (no change needed)

      when the result is 1,03 = 1.

      when the result is 1,34 = 1.