Showing results for 
Search instead for 
Did you mean: 

Setting Insertion formula for repeating pattern in Crosstab

0 Kudos

I'm using Crystal Reports 2016 SP7 Patch 9.

I have a Crosstab that's Grouped by Company, Currency, Identifier and a Code for the rows. The Columns are a Sum of Balance and Sum of Converted Balance.

I need to insert a row after the Identifier "FX" (or before the "Net Exposure" total). The calculation will be

(CFlow - Net Exposure)/CFlow for the Balance and Convert Balance columns.

I haven't figured out the correct insertion formula to insert at each occurrence of "FX".

The report grouping is Company, Currency and Date. The crosstab is placed in the Company Group Footer.

In the Calculated Member, what role does the Edit Row Value Formula and Group Level play? Insertion Formula is my main issue. Only place the row has inserted using trial and error is as the last row in the crosstab.

Here's some screen shots of my Calculated Member:

//The insertion formula determines where this calculated member is inserted. It must return a Boolean value.

CurrentRowIndex = 2

//The header text is shown in this row/column's header. It must return a String value.

"CFlow - Exp Ratio"

For the moment, I'm using the first Summary until I get the Insertion Formula to work. I'm sure I'll run into issues with the final Calculation formula once insertion is working.

Here's the design for the Crosstab:

Company (Cpty), Currency (Curr) Code (Hedge Code) and GrandTotal are using the same settings. Identifier (SubIdentifier) has the Group Options Suppress SubTotals checked.

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Un-suppressing the Sub Identifier was my Insertion issue. Now I'm trying to figure the correct calculation to get the Total to the right of the Net Exposure.