How to create and use a List with Number of weeks to each Fiscal Month in the module ?
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.