To add a calculated field to divide two fields in Cross Tab

[Former Member]

Hello,

I need to add a calculated field to divide two fields in Cross Tab

……………..Jan…. Feb….. March…… Etc.
Hours1……. 45…... 29……. 34 ..
Hours2……. 42 28……… 31
Calc Field… 1.07…1.04…..1.1

The "Calc Field" I want to take the Hours 1 and divide it by Hours2 .

Any advice and suggestions will be greatly appreciated.

Thanks in advance!

[abhilash_kumar · Accepted solution]

Hi Alisia,

1. Right-click the "Hours2" cell > Calculated Member > Insert Row. A blank Row with zero values should be inserted at the end.

2. Right-click the blank cell below "Hours2" > Calculated Member > Edit Header formula.

Type in a header label of your choice in double quotes.

3. Right-click any summary cell in this new row > Calculated Member > Edit Calculation formula > Use this code:

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

-Abhilash

[Former Member · Accepted solution]

A big thanks Abhilash for always being very helpful!