Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I'm trying to make an incremental sum of fields.
Using an import table:
Test1 | Test2 | Test3 | Test4 | Test5 | Test6 |
1 | 1 | 1 | 1 | 1 | 6 |
2 | 2 | 2 | 2 | 2 | 1 |
3 | 3 | 3 | 3 | 3 | 2 |
4 | 4 | 4 | 4 | 4 | 3 |
5 | 5 | 5 | 5 | 5 | 4 |
6 | 6 | 6 | 6 | 6 | 5 |
7 | 7 | 7 | 7 | 7 | 6 |
8 | 8 | 8 | 8 | 8 | 7 |
9 | 9 | 9 | 9 | 9 | 8 |
And one table with fields like that:
Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | Expression1 | Expression2 | Expression3 | Expression4 | Expression5 |
1 | 1 | 1 | 1 | 1 | 6 | Test1+Test2 | Test1+Test2+Test3 | Test1+Test2+Test3+Test4 | Test1+Test2+Test3+Test4+Test5 | Test1+Test2+Test3+Test4+Test5+Test6 |
2 | 2 | 2 | 2 | 2 | 1 | Test1+Test2 | Test1+Test2+Test3 | Test1+Test2+Test3+Test4 | Test1+Test2+Test3+Test4+Test5 | Test1+Test2+Test3+Test4+Test5+Test6 |
3 | 3 | 3 | 3 | 3 | 2 | Test1+Test2 | Test1+Test2+Test3 | Test1+Test2+Test3+Test4 | Test1+Test2+Test3+Test4+Test5 | Test1+Test2+Test3+Test4+Test5+Test6 |
4 | 4 | 4 | 4 | 4 | 3 | Test1+Test2 | Test1+Test2+Test3 | Test1+Test2+Test3+Test4 | Test1+Test2+Test3+Test4+Test5 | Test1+Test2+Test3+Test4+Test5+Test6 |
5 | 5 | 5 | 5 | 5 | 4 | Test1+Test2 | Test1+Test2+Test3 | Test1+Test2+Test3+Test4 | Test1+Test2+Test3+Test4+Test5 | Test1+Test2+Test3+Test4+Test5+Test6 |
6 | 6 | 6 | 6 | 6 | 5 | Test1+Test2 | Test1+Test2+Test3 | Test1+Test2+Test3+Test4 | Test1+Test2+Test3+Test4+Test5 | Test1+Test2+Test3+Test4+Test5+Test6 |
7 | 7 | 7 | 7 | 7 | 6 | Test1+Test2 | Test1+Test2+Test3 | Test1+Test2+Test3+Test4 | Test1+Test2+Test3+Test4+Test5 | Test1+Test2+Test3+Test4+Test5+Test6 |
8 | 8 | 8 | 8 | 8 | 7 | Test1+Test2 | Test1+Test2+Test3 | Test1+Test2+Test3+Test4 | Test1+Test2+Test3+Test4+Test5 | Test1+Test2+Test3+Test4+Test5+Test6 |
9 | 9 | 9 | 9 | 9 | 8 | Test1+Test2 | Test1+Test2+Test3 | Test1+Test2+Test3+Test4 | Test1+Test2+Test3+Test4+Test5 | Test1+Test2+Test3+Test4+Test5+Test6 |
But instead use the formula, I want to use Variables like:
Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | Expression1 | Expression2 | Expression3 | Expression4 | Expression5 |
1 | 1 | 1 | 1 | 1 | 6 | Variable1 | Variable2 | Variable3 | Variable4 | Variable5 |
2 | 2 | 2 | 2 | 2 | 1 | Variable1 | Variable2 | Variable3 | Variable4 | Variable5 |
3 | 3 | 3 | 3 | 3 | 2 | Variable1 | Variable2 | Variable3 | Variable4 | Variable5 |
4 | 4 | 4 | 4 | 4 | 3 | Variable1 | Variable2 | Variable3 | Variable4 | Variable5 |
5 | 5 | 5 | 5 | 5 | 4 | Variable1 | Variable2 | Variable3 | Variable4 | Variable5 |
6 | 6 | 6 | 6 | 6 | 5 | Variable1 | Variable2 | Variable3 | Variable4 | Variable5 |
7 | 7 | 7 | 7 | 7 | 6 | Variable1 | Variable2 | Variable3 | Variable4 | Variable5 |
8 | 8 | 8 | 8 | 8 | 7 | Variable1 | Variable2 | Variable3 | Variable4 | Variable5 |
9 | 9 | 9 | 9 | 9 | 8 | Variable1 | Variable2 | Variable3 | Variable4 | Variable5 |
Where:
Variable1 = Test1+Test2
...
Variable5 = Test1+Test2+Test3+Test4+Test5+Test6
But is not working.
Can anyone help me?
Thanks
You need to remove the = from the expressions in the variables (so they are evaluated in the chart and not beforehand where the Teste fields don't have values yet) and dollar-expand the variables in the expressions in the straight table. See attached qvw.
You need to remove the = from the expressions in the variables (so they are evaluated in the chart and not beforehand where the Teste fields don't have values yet) and dollar-expand the variables in the expressions in the straight table. See attached qvw.
Hello Gysbert,
Thank You so Much!
I have tested without "=" before but didn't work because the way that I was calling the variable was wrong!
Now is perfect!