Skip to Content
0

Croostab Differences Calculation column position and formulas

Feb 09, 2017 at 04:33 PM

205

avatar image
Former Member

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

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

17 Answers

Abhilash Kumar
Feb 10, 2017 at 08:20 AM
0

Hi Luis,

Please attach the report with 'saved data'.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 24, 2017 at 04:23 PM
0

Thanks for your reply,

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 24, 2017 at 04:24 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 24, 2017 at 04:25 PM
0

Give me your email to send the file.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 24, 2017 at 04:25 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 10, 2017 at 10:15 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 24, 2017 at 04:27 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 24, 2017 at 04:27 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 17, 2017 at 03:29 PM
0

send me an email to to share the file.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hello,

It is not allowed to publish your Email

0
avatar image
Former Member Feb 11, 2017 at 03:02 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded