topic Re: Conditional Month into Weekly Targets in App Development

Conditional Month into Weekly Targets

Ron1 — Thu, 06 Feb 2020 07:34:38 GMT

I have my below input table for monthly target

My requirement is for weekly target by weekending on Sunday.

If the weekending is on 1st or 2nd of a month then previous month target will be taken into account

If the weekending is on 3rd of a month onwards, then current month target will be taken in place.

My desired output is as below: (It's a bit complex, so kindly help me as I am stuck since last 2 days)

Vegar — Thu, 06 Feb 2020 07:56:00 GMT

You would need to find the month and year of each Friday in the desired period.

In the below expression I calculate the month of the Friday in the fifth week of 2019.

Month(MakeWeekDate(2019, 5 , 4) ) as Month,

Year(MakeWeekDate(2019, 5 , 4) ) as Year

Try to utilize these in order to get the right associations to your monthly week targets.

Ron1 — Thu, 06 Feb 2020 08:56:36 GMT

If I have to script the same for the small data set which I have provided how to implement the same?

I did not get your logic.

Ron1 — Mon, 10 Feb 2020 13:24:01 GMT

The same has been achieved using a joining key and a date calendar having max date and min date. Then using while, pick up all dates for week end.

Then have a join and provide a condition over there to achieve this