Skip to Content

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

Showing Dates Outside Range of TimeDim() Function

Hi,

I have compiled a report and I have used the TimeDim() function to fill in dates within the range.

This has worked to a great extent but when I filter my chart to show another Source Y, e.g. another product, then the beginning and end of the month dates do not show on the chart since they are seen as empty dimensions.

Is it possible to apply the dates from Source X to my filtered chart of Source Y without affecting the results of my chart?

I've tried all sorts of methods but to no avail and I will appreciate advice and suggestions to my query.

Thank you,

Jaspal

Former Member
Former Member replied

Hi guys!

I figured it out and it was a lot simpler than what I thought it would be

I removed the filter on the chart and created a new variable

=[Average Turnaround (Minutes)] Where ([Contract Source] InList("SourceY"))   where SourceY has been renamed but relates to the product

I have to amend the average line now!

EDIT: Amended average line formula

=Interpolation(Round(Sum([Paid Out Turnaround Time (Minutes)])/Count([Contract Number];All);0) In ([Contract Source]) Where ([Contract Source] InList("SourceY")))

finally!

0 View this answer in context

Helpful Answer

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