I created a collection with columns, in which I save the values that are selected in a "slider" (Slider1_1) and in another one I save that value transformed to a predetermined scale (Slider1_1Complexity). Up to here, everything is working.
I would like to be able to create a new column in which I store the sum of what I call complexity (Slider1_1Complexity + Slider1_2Complexity). I tried Sum(Slider1_1Complexity + Slider1_2Complexity) but it doesn't work.
Is it possible to do this?
My code:
Collect(
Form2_Programs,
{ Slider1_1: Slider1_1.Value,
Slider1_1Complexity: If(Slider1_1.Value <= 4, "0", Slider1_1.Value <= 7, "0.5", Slider1_1.Value <= 10, "1"),
Slider1_2: Slider1_2.Value,
Slider1_2Complexity: If(Slider1_2.Value <= 4, "0", Slider1_2.Value <= 7, "0.5", Slider1_2.Value <= 10, "1"),
sum: Sum(Slider1_1Complexity, Slider1_2Complexity)
}
)