I am trying to accomplish 3 things using set analysis and FABS but having issues using Date(AddMonths(monthstart(today()),6))) and FABS:
- Create a gauge chart for the next 6 months
- 1-(sum(FABS([Assigned Hours]))/sum([Available Hours]))
- create a gauge chart for the current month
- 1-(sum(FABS([Assigned Hours]))/sum([Available Hours]))
- create a stacked bar chart for the next 6 months
- Available hours: sum({<[CHKBK_MONTH]={">=$(= Date(AddMonths(monthstart(today()),6)))>=$(=monthstart(today()))"}>} [Available Hours])
- Assigned Hours: sum({<[CHKBK_MONTH]={">=$(= Date(AddMonths(monthstart(today()),6)))>=$(=monthstart(today()))"}>} FABS([Assigned Hours]))