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.
Eugene Khusainov replied
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!