Hi,
x and n are both numbers and are calculated by me during the workflow. I have two issues:
1) How can i store x and n while I am executing my workflow? Also, how do I access these values in maybe a formula tool later in my workflow. As an analogy, I create 2 variables during my program execution, store it and later use it.
2) If I have x as one number and n as another number. Example, x=3 and n=4 then I want to sum the values in columns 3 to 7 (3+4) for every row.
My file has several weeks and the numbers x and n change for every week. So i want the way I sum to be dynamic and be able to decide on runtime as to which columns to sum.
