How to add New Summarised field in Cross Tab ?

[Former Member]

Dear Experts ,

I designed a cross tab report and every thing is working fine .., Now i need to add a new summarise fields next to Actual amount .

I create a formula Total

if isnull ({R00068_2.BUDGETED_AMOUNT} )

then

0

else

({R00068_2.ACTUAL_AMOUNT}/{R00068_2.BUDGETED_AMOUNT})*100

But i am not getting correct amount ,getting same total for every group . Please check my image file , What formula i need to write .

[abhilash_kumar · Accepted solution]

Hi Sriram,

That'll never work!

You need to use Embedded Summaries instead. If you're using CR 2008 or higher, here's what you need to do:

1) Remove the @Total formula from the Crosstab

2) While in the Preview Mode, right-click the Actual Column and select Embedded Summary > Insert Embedded Summary

3) You should see cells with the text 'Edit this formula'. Right-click one of those cells and select Embedded Summary > Edit Calculation formula and use this code:

if GridValueAt(CurrentRowIndex, CurrentColumnIndex, CurrentSummaryIndex-2) = 0 then

0

else

(GridValueAt(CurrentRowIndex, CurrentColumnIndex, CurrentSummaryIndex-1)/GridValueAt(CurrentRowIndex, CurrentColumnIndex, CurrentSummaryIndex-2))*100

Let me know how this goes.

-Abhilash

[Former Member · Accepted solution]

Its Really Helpful ,

Thanks Abhilash ,

I Tried in CR version 13 there is no option available  , so now I downloaded trial version of CR Version 14 , designed in that and I will use in Visual Studio ...