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

# 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)

(((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!

• ###### Re: Variable creation

Yes. it is possible.

Try adding your variable in Data Load Editor. like below.

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

And then reference this in your expression like below.

((\$(vExp)/22)*10) +(sum([Total Time Spent]))/(sum(timeuser)*10)

Find attached for you reference.

• ###### Re: Variable creation

Jose,

Can you mark this thread "Correct Answer"  if above solution solves your problem. That way other people can find this useful.