Is it possible to do a Were Do statement is Cognos rather than and If then Else Statement.
Im trying to write a Profit and Loss report. I have a prompt to get the required period but i also need the previous three periods to show also. Ive been using the calculation total(if (period = prompt-1) then amount else null). Id actually like this to read Were (period=prompt-1) do....
I have coded the were period in the filter but i actually need the were in the calculation also.
Help
Im trying to write a Profit and Loss report. I have a prompt to get the required period but i also need the previous three periods to show also. Ive been using the calculation total(if (period = prompt-1) then amount else null). Id actually like this to read Were (period=prompt-1) do....
I have coded the were period in the filter but i actually need the were in the calculation also.
Help