Hi All,
Below is the example on my requirement. Based on the month and balance i need to calculate the trial balance which is cummulative.
Month Balance Trial Balance
1 234 234
2 543 777
3 215 992
4 533 1525
5 344 1869
The req is i have month prompt and when i select value 4 the output list should have one row for month 4 with cummulative trial balance as below. What calculation can we do at the report level to get this?
Month Balance Trial Balance
4 533 1525
thanks,
Manoj
Cumulatives are calculated by the Cognos engine, based on the query data fetched. The balance of month 4 is therefore generated by using months 1,2,3 and 4
You can very simply hide the list column bodies based on a boolean variable that checks for :
[month] = 4
Set box type to none for the 'no' value of the variable..