asked on

Calculated Member Cross Tab Insertion Formula

I have a report that is using calculated member in a cross tab. The "insertion formula" is making it show up after a specific column
"GetRowGroupIndexOf(CurrentRowIndex) = 1 and GridRowColumnValue("glaccnttype.glaccnttype_id") = "Overhead Taxes - Income""

Problem is this Row of Data "Overhead Taxes - Income"" is not in all reports depending on date range ran.
This is an income statement and depending on the date ranges there are variable numbers of Rows of data.

How do I write the insertion formula to simply have it display at the end of the report?
My three calculated members are below and each has the exact same insertion formula and show up when the account "Overhead Taxes - Income"" displays

Total Revenue
Total Expense
Net Revenue

Mike McCracken

Can you change the order of the columns so the last column is always there?

mlmcc

Lisa Jasperse

ASKER

No, this is an income statement and is required in a specific order. Some companies have expenses that others so not.
This is for three fields:
Gross Income
Expenses
Net Income (Gross Income - Expenses)

I was very excited to come across this calculated member, but am struggling to make it appear at the end of every companies statement.

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.