Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

help with crosstab formula

Dear all, I have created a "Display String Value" formula for one of my field in crosstab. The field distinct counts the number of orders against number of days.

The formula which I have used shows or displays percentage of the current field value however I would like it to show cumulative percentage instead of normal percentage.

Here is the senario:

Crosstab ---> Summary --> DistinctCount({orderheader.ordernumber}) / Column (number of days)

Formula - Display String Value

Whileprintingrecords;
Numbervar h:=Currentfieldvalue;
Numbervar g:={@TotalJobs-CanceledJobs};
Numbervar b:=0;
b:=((h/g)*100);
totext(b,2) + "%";

Formula for TotalJobs-CanceledJobs

Whileprintingrecords;
Numbervar x:={#Total_Jobs};
Numbervar y:={#Cancelled};
Numbervar z:=0;
z:=(x-y);
z;

Any ideas how I can edit the display string formula so that it shows cumulative percentage?

Regards

jehanzeb

Not what you were looking for? View more on this topic or Ask a question