Cognos Calculation Report Studio 1

[borntorun]

Hi,

I have no access to framework and I need to perform the following calculation, I would like to work out the easiest way of doing it.

Count(itema) / (itemb/1000) grouped by date.

I could write the sql myself but only want to do this if it is the easiest way.

Thanks for any pointers.

 

[blom0344]

This makes sense if itemb and date have a 1:1 relationship (like coming from the same table)
Then change the aggregation behavior of itema to count (use a new query calculation) and create a calculation with new query calculation and itemb) Then group on date.

Ties Blom