Good afternoon,
I have a requirement where my user needs to choose a few months and have me add up the numbers that are in the associated columns for a column in the output. I am working with relational data. my table looks like this:
Jan Feb Mar Apr
Part 5 5 6 8
So the user chooses Months (ie Jan and Feb) and the calculated item would be 10.
I have tried #prompt, #promptmany... I cannot seem to get this working.
Any ideas?
Thanks!
Assuming that's your table, rather than a crosstab built over your table, you're probably going to want something like:
January: if(?pMonth? contains 'Jan') then ([Jan]) else (0)
February: if(?pMonth? contains 'Feb') then ([Feb]) else (0)
etc.
You could also have some render variables that only show the columns that you select in your prompt. At the end of your report you'd then have a field for
Total: [January] + [February] + [March] etc.
Thank you, that worked perfectly!