Croostab Differences Calculation column position and formulas

[former_member387162]

Hi,

I created a croostab report with [As_Of_Date] column, [Current Balances] Values and [Products] rows. Now I put the Differences Variance for the columns but does not allow me to move the columns and if you change the dates of selection displays an error of arguments. I check this in the Calculate Member formula and the issue is when the As Of Dates changes then cracks the formula because the formula recorded previously CDateTime (2017,2,6,00,00,00).

On the other hand i need to be able to move the columns of Differences to the left.

I Saw this post https://archive.sap.com/discussions/thread/3434351 for abhilash.kumar and it's works but generate a difference column calculation for the next column of As of date.

The Differences calculation must be:

{Yesterday}-{Before Yesterday} Like 2/6/2017-2/3/2017

{Yesterday}-{Last Month Date} Like 2/6/2017-1/31/2017

{Yesterday}-{Last Year Date} Like 2/6/2017-12/30/2016

{Yesterday}-{Oct 7 2016} Like 2/6/2017-10/7/2016

See that I need crosstab-sample.gif

[former_member387162]

Hi,

It's possible two put any generic formula value in the insertion formula for the calculated member?

For example: CDateTime (2017,03,22,00,00,00) when I refresh to change this date to 3/23 the calculated member that show me the variance is missing.

So, I try to create many formulas to display the CDateTime value estructure with no result.

Any idea for this.

[former_member387162]

As I can say to croostab that has fewer columns so that this message does not appear.

Some help with this please!

[former_member387162]

crosstab-message.gif

Hello Abhilash,

Recently I put in the calculate member this formula por each column GridValueAt (CurrentRowIndex, GetNumColumns - 2, 0) - GridValueAt (CurrentRowIndex, 5, 0) and right know I have 4 columns and I received the message (see attached). What is the syntax to recognize this change?

[former_member387162]

Hi Kumar, I have Deski tool and I saw this syntax for the same report. The formula in the variable field is:

This is for the variance yesterday minus before yesterday.

<current balance>where [asofdate]='2/6/2017'-<current balance>where [asofdate]='2/3/2017'

It's possible to create any syntax similar in the formula for crystal reports and put in the croostab column?

[former_member387162]

Hi Kumar, Let me know if you provide me any email for share the report.

[former_member387162]

Hi Kumar, Let me know how to share the file rpt. I try to Upload but the Web do not accept this extension.

[former_member387162]

Give me your email to share the file report. Thanks!

[former_member387162]

Give me your email to send the file.

[former_member387162]

The application not accept this extension format. Let me know how I share the file report.

[former_member387162]

Thanks for your reply,

Let me know how to upload the file .rpt? Is not a valid extension file.

[former_member387162]

send me an email to to share the file.

[moshenaveh]

Hello,

It is not allowed to publish your Email

[former_member387162]

Good question. The croostab change to four if the last month is my before yesterday. For example if I need the difference for 2/1/2017 to 1/31/2017. That's the only way to change because my last month is my before yesterday.

[abhilash_kumar]

Hi Luis,

Would this crosstab always have five columns?

-Abhilash

[former_member387162]

Thanks, Moshe I am new be in this. So I paste a link to share the file.

https://drive.google.com/file/d/0B_dwied3vbGVUUFWZmZfQmR2Z0k/view?usp=drivesdk

I don't know if this work till share.

[former_member387162]

Hi Kumar, I can't share the file by the Web is not accept the upload.

[former_member387162]

Hi Kumar, Let me know to send to you the file.

[abhilash_kumar]

Hi Luis,

Please attach the report with 'saved data'.

-Abhilash