Low Level Calculation Roll Up

[Smokey]

Hi, can anyone help me with a problem in report studio v8.2

I have a list report from a cube to which i have added calculated column. The calculation can only be applied at the type level to get the correct result:

Date       Type  Inc  Total True_Inc
01/11/09   ex     1      10       1
01/11/09   pr    10      10       0
01/11/09   sf      5       7       5

The formula in true_inc is if inc=total then 0 else inc

What I want to do is then have a second report based on the result of this list report which adds the true_inc by date. However each time i try the second report returns the result = to the total of inc not true_inc. It obviously is rebuilding the formula at the consolidated level.

Is there anything I can do or do I have to redesign the cube?

Any help welcomed.

Smokey

[Gollapudi]

Where did you use this formule.. in Report Studio or in Transformer.... ?

The formula in true_inc is if inc=total then 0 else inc

[Smokey]

Its in report studio as a calc column, originally the report was directed at the datawarehouse table. I'm suprised you can't have sub queries in a report which can be used by another query.

I've now created a cube in transformer to do the work but it's still not quite right... i'll keep at it....calculating at the summarised level based on the detail is causing me problems.

On a different report but same principal, would using conditional formatting to render rows hidden if true be expected to slow the run time of a report considerably?