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!

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