I have the need to build new variables. Eg: Let's say I have one variable called Year and another called salessprint. And for sake of argument, let's say these sprints might have different periodicity.
To simplify charts for showing this, I might wanna create a variable which contains year+sprint in one variable
yearsprint = year * 100 + sprint.
I recon I do this with event based rules in the database, however, these sort of formulas are not available here. I would appreciate the addition of being able to do calculations like this.