Year To Date (YTD) summary column not showing data
I created one module, in which I added Time Range i.e FY 18, Number of Periods = 1, and Aggregation as Year To Date. For testing purpose, I added some data in some periods. I can see total amount under FY18 (Summary column), but no data appearing under YTD column.
I have another query related to YTD calculation. If YTD is calculated based on current period set under model calendar, then what would I need to do when business wants to see YTD calculation from Jan to Dec.
For instance, I have set current period as Jan 20, If user enters $10 in Jan 20, the YTD value should be $10.
If user enters $15 in Feb 20, then YTD value should show $25.
If user enters $10 in Mar 20, then YTD value should show $35.