Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, guys!
I'm stuck with set analysis in my straight table.
I need to get a sum of days for the period: from the month picked by user in my "Months" filter till Dec- 2015.
For this purpose I used the following expression:
Sum({<Month_Date={">=$(=Date(addmonths(Month_Date,1),'MMM-YY')<='Dec-15'"},Month_name=>} Days)
But it's not working!
I also need sum of days for previous month ( the one before the month that picked by user in "Months" filter) :
Again the expression I used:
Sum({<Month_Date={"=$(=addmonths(Month_Date,-1)"},Month_name=>} Days)
Again the same result as the previous one.
Can anybody please help me to sort this out?
Sample app is attached.
Hi,
Just try to change Min(Month) to Max(Month).
=Sum({<Month_Date={'>=$(=Max(Month_Date))<=$(=Max({1}Month_Date))'},Month_name=>} Days)
See if this is what you wanted:
Vacations current month till December
Sum({<Month_Date={"$(='>=' & Date(addmonths(Max(Month_Date),1),'MMM-YY') & '<=' & Date(YearEnd(Max(Month_Date)), 'MMM-YY'))"},Month_name=>} Days)
Prvious Month
Sum({<Month_Date={"$(=Date(addmonths(Max(Month_Date),-1), 'MMM-YY'))"},Month_name=>} Days)
It doesnt seem to work properly. It doesnt sum up all the values starting from the picked month till December
It would be ideal if you can let me know some selections and expected results when we make those selections. I am not familiar with the expected output.
I hope that makes sense.
Best,
Sunny
Hi,
may be like this
=Sum({<Month_Date={'>=$(=Min(Month_Date))<=$(=Max({1}Month_Date))'},Month_name=>} Days)
For example, if u choose July in the filter and then look the first on in the table of employee (Emp_name: Aaelyjkig Wvfq), the sum of days for this employee is 0 now. However it should be 7. The total of the column "Vacations current month till December" should be 110 for July, and now it's 35.
Nope, it shows the sum of all year
Hi,
Just try to change Min(Month) to Max(Month).
=Sum({<Month_Date={'>=$(=Max(Month_Date))<=$(=Max({1}Month_Date))'},Month_name=>} Days)
Hi ,
Please find the attached sample.It may be your desired result i think.
For Previous Month
=Sum({<Month_Date={"$(='>=' & Date(AddMonths(Max(Month_Date),-1),'MMM-YY'))"}>}Days)