Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi further to a previous post i am using set analysis to dispay one value in a text box.
My simplified data is as below:
ID | Area | Manager | Status |
Backlog1 | Northwest | Jenny | Active |
Backlog2 | Northeast | Steve | Closed |
Backlog3 | Southwest | Mike | Active |
InProgress1 | Southeast | Carol | Closed |
I am using =Only({$<ID={Backlog1}>} Area) to display in a text box the Area related to the first ID and another for the second and so on.
What i want to do is make the ID in the set analysis a variable (so that i can set some record set selection buttons up)... I assume that i can do this with a straight variable - i.e. a variable with a value of "Backlog1" (or "backlog"& number) however is there a way for me to do that within the formula itself.
To put another way is it possible to create a set analysis that has a string concatenation like this =Only({$<ID={"Backlog"&vNum}>} Area) combining the word backlog and the variable number?
As always looking forward to suggestions!
Thanks
Chris
Hi Chris,
Is there any reason why you wouldn't just create a variable that contained the full text, e.g. Backlog1, Backlog 2, etc.? Concatenating within a set analysis expression, whether possible or not, will make your expression less readable.
Hi,
Partly curiosity to see what the art of the possible is, but also scaleabilty - if i have say 10 IDs for "backlog" i also have items for 5 other catagories that I would be looking to do the same for (e.g. InProgress1 from the example above)...
therefore if i held the full text in the variable i would require variables for 10 items x 6 catagories = 60 variables.
If i can do it within the formula i can hold just the numbers in the variables and amend the formula for the catagories... that way i would only hold 10 variables.
Thanks
Chris