Hello, I'd been lately struggling a lot with a Piechart that need to show the sum of work hours of the next month selected.
Originally I had this formula which calculate the dedication of the next month of the actual date:
LET vNextMonth = Year(AddMonths(Today(),+1))&Num(Month(AddMonths(Today(),+1)),00); in script
SUM({< AssignmentTimephasedDataSet.YearMonth={$(vNextMonth)}>} AssignmentTimephasedDataSet.AssignmentWork) in my Piechart Expression
I tried this formula:
SUM({< AssignmentTimephasedDataSet.YearMonth={"=$(=max(AssignmentTimephasedDataSet.Month_Year)+1)"}>} AssignmentTimephasedDataSet.AssignmentWork) but everytime I select a month it shows me the info of the month selected not the next one.
Any help?
