Skip to Content
0
Sep 04, 2018 at 07:48 AM

How to get the value of first month of the quarter in WebI

131 Views

Hi guys, I have a table like that

Date Stock

01-01-2017 7

01-02-2017 5

01-03-2017 4

01-04-2017 6

01-05-2017 9

01-06-2017 3

01-07-2017 5

01-08-2017 11

01-09-2017 12

01-10-2017 10

01-11-2017 6

01-12-2017 7

User has a prompt to enter the Date value.

I want to create new variable it shows a first month value of the selected quarter.

For example If the user select 01-05-2017 on prompt then it returns 6. for 01-12-2017 returns 10.

How can i do that on Webi ?

Thanks

Gory.