I created a list "Months Flat" (Jan--Dec) with Top Level as 'All Months' and added Property - 'Number of Weeks' and assigned values tothe property -- 445445454445.
Then I am in a module, I need to Lookup at the 'Number of Weeks:
For example: For every April irrespective of Year like Apr16 or 17 or 18, it should show me '4'.
I am not able to Map Fiscal Months with 'Number of Weeks'.
What formula should i be using to pull number of weeks from the list ?? or something else I am missing ????
th Number of weeks.
Go to Solution.
The following solution requires that the codes of months flat list are month numbers from 1 to 12.
- Create an additional line item to the module. Let's call it "Month". Format it with the months flat list.
- Add formula to the new line item: FINDITEM(Months Flat, TEXT(MONTH(ITEM(Time))))
- This will find a correct member of the months flat list for each month. Mapping is based on the codes of months flat list.
- Use the following formula for fetching number of weeks from the list property: Months Flat.Number of Weeks[LOOKUP: Month]