Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
Jose,
Can you mark this thread "Correct Answer" if above solution solves your problem. That way other people can find this useful.