Skip to Content

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

Query Exclusion

I have two dates in my Purchase Order Cube; 1) Document date and 2) Invoice date.

Is it possible to write a query that only shows data where Document Date is later than the Invoice Date? I can see in the Query Designer that there are some exclusion options for key figures but nothing for dealing with dates.

Thanks!

Former Member
replied

Hi Patrick,

You need to create 2 formula variables of replacement path on your 2 dates. Then in the structure create a formula with these 2 variables difference. Say, it'll be greater zero or less than zero. Create a condition on this last formula and you are done!

Best regards,

Eugene

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