2 Replies Latest reply: Oct 7, 2014 7:01 PM by Phaneendra Kunche RSS

    Variable creation

      Can I create a variable in order to be used afterwards in other formulas?

       

      if((sum(timeuser)*22)-((sum([Total Time Spent])/10)*22)<0,0,((sum(timeuser)*22)-((sum([Total Time Spent])/10)*22))*Valor/100) as Variable

       

      So I can use it then as

      (Variable/22)*10) +sum([Total Time Spent]))/(sum(timeuser)*10)

       

      instead of

      (((if((sum(timeuser)*22)-((sum([Total Time Spent])/10)*22)<0,0,((sum(timeuser)*22)-((sum([Total Time Spent])/10)*22))*Valor/100)/22)*10)+sum([Total Time Spent]))/(sum(timeuser)*10)

       

      Thanks!