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?
Hi Luis,
Do you want the calculated member column to be placed at the beginning or end of all other columns?
-Abhilash
The current position of the column counting from right to left and considering the total column is the fourth.
Why the order is important?
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
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.
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.
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
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.