cancel
Showing results for 
Search instead for 
Did you mean: 

Finding out the num of Days in query

Former Member
0 Kudos

Hello Experts,

I have a scenario where in I have 2 dates. One is Goods issue date and the other is Goods return date. I need to find out the no. of days between the Goods Issue and Goods return date . How do i implement this in my report?

Would be assigning points for suitable ans.

Regards

Rohit

Accepted Solutions (1)

Accepted Solutions (1)

former_member189638
Active Contributor
0 Kudos

Create two Formula variables with Processing type as replacement path to pull both the dates.

Then you can use this variables in a Formula Key Figure to calculate the difference. This will give you the number of days.

Answers (1)

Answers (1)

pruthvi_r
Contributor
0 Kudos

Hi,

Please refer the following link for step by step process:

http://www.sd-solutions.com/documents/SDS_BW_Replacement%20Path%20Variables.html

Hope it helps

regards,

Pruthvi R