Skip to Content
0
Jul 27, 2023 at 05:29 PM

How to pass Date values from BEx query output to Key Figure Calculation ?

325 Views

Hi ,

I have a requirement to populate data based on User Input on Date selection and Some of the Key figures needs to be calculated Dynamically based on output data.

Example:

User Input on Date : 01.06.2023

Output

image.png

In above example, based on User input date (01.06.2023), PO Latest date needs to be picked. This I am able to achieve in BW query (taking Last Value).

Now for the column "Billed Qty", I need to calculate and populate based on "PO Latest Date" coming in the output for each Plant and Material wise. The Tricky part is "Billed Qty" is based on "Posting Date" whereas "PO Qty" is based on "Calender Day".

How Can I pass the date populated in the column "PO Latest Date" (Calendar Day) to "Billed Qty" (Posting Date) Column dynamically ?

Attachments

image.png (8.6 kB)
image.png (15.4 kB)