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

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

Formula for TotalJobs-CanceledJobs

Numbervar x:={#Total_Jobs};
Numbervar y:={#Cancelled};
Numbervar z:=0;

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



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