Skip to Content
0

Value in Calculated Member Insertion Formula do not change when refresh report Croostab

Apr 05, 2017 at 01:31 PM

121

avatar image

Hi All,

I have a Croostab report that have this formula in an Insertion Formula calculated member:

GetColumnGroupIndexOf(CurrentColumnIndex) = 1 and GridRowColumnValue("TABLE_NAME.AS_OF_DATE") = CDateTime (2017, 02, 28, 00, 00, 00).

When I refresh my report to change this date then my calculated column in the crosstab is missing. If I proceed to change manually this value then the report display correct my column calculated.

Is possible to put any formula for a generic value when dates changed?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

7 Answers

Abhilash Kumar
Apr 06, 2017 at 08:34 PM
0

Hi Luis,

Do you want the calculated member column to be placed at the beginning or end of all other columns?

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
Luis Oscar Apr 07, 2017 at 01:14 AM
0

The current position of the column counting from right to left and considering the total column is the fourth.

Why the order is important?
Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Apr 07, 2017 at 07:56 AM
0

If you want the Calculated Column to appear at the end, here's what you need to do:

1. When you create the Crosstab, the Total Column is the first column. Right-click this column > Column Grand Totals > uncheck 'Totals on Left'.

This moves Total to the end.

2. Right-click Total Column's header > Calculated Member > Insert Child.

3. This adds a blank column to the very beginning. Right-click the blank space to the top left of the Crosstab > Advanced Calculations > Calculated Member > Change the "Insert Evaluation" to "After"

4. The Calculated Member column is now at the end of all Data columns and just before the Total column.

The Column is now independent of the data.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
Luis Oscar Apr 07, 2017 at 07:12 PM
0

ok, I review this but my first issue is to resolve how the insertion formula stop missing the column when I refresh my report. When the value changed.

Share
10 |10000 characters needed characters left characters exceeded
Luis Oscar Apr 09, 2017 at 10:55 PM
0

ok, I view this discussion and that is similar to my issue:

https://archive.sap.com/discussions/thread/3277155

Ok, let me say if my column is the fourth position but is based the calculation for the 3rd column I put insert formula like mentioned in the previous site.

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Apr 10, 2017 at 08:17 AM
0

Hi Luis,

The insertion formula should never reference a 'value'. If it does, then the calculated member could disappear if it can't find that value.

If your crosstab always returns 3 columns and you want the calculated column to appear as the 4th column, you should instead use an 'index' in the insertion formula:

CurrentColumnIndex = 3

If your crosstab could return different number of columns, then you should use the method I described in my initial response here to place the calculated member towards the end.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
Luis Oscar Apr 10, 2017 at 06:05 PM
0

Oh, I confused the position with the value sorry. So, corresponding for the value I try to format CDateTime and put a formula that divide year, month, day but nothing happens. Let me said I created one formula for each year, month ,day and after that I made a formula like this:
name formula DT= {@year},{@month},{@Day},00,00,00. After this I put in my calculate member CDateTime ({@DT}).

I don't know is that it's correct.

Share
10 |10000 characters needed characters left characters exceeded