Skip to Content

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

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 17 at 08:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded