Hello @janxsch
I’m sorry, I don’t understand your question because for summing values, you only should use the “+” operator: A+B+C+D, etc.
Best regards.
i wanna calculate with this ∑
how can I do it?
Hello @janxsch
If you want to sum an array of values, you can use the SUM operation:
SUM([a,b,c,d])
where a,b,c, and d, can be replaced by numbers or by the field names.
Best regards.
i wanna calculate this sum(n;0;4;12*500*1,05^n). how?
sum(index;lower limit;upper limit;sequence), this is the english syntax
Hello @janxsch
In this case, you must use a loop in the calculated field equation:
(function(){
var result = 0;
for(var n = 0; n<=4; n++){
result = SUM(result, 12*500*POW(1.05,n));
}
return result;
})()
Best regards.
