Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to do the below formula with a date filter of 12/01/2017. Any assistance appreciated.
count([2])*2+count([3])*3+count([4])*4+count([5])*5+count([6])*6+count([7])*7+count([8])*8+count([9])*9+count([10])*10)/(Count([Employee_ID])
What exactly you need help for? Can you share dimension, measures, sample data, expected output to respond appropriately.
The same set expression would need to be added to each count():
count({$<date={"12/01/2017")>} [2])
Note your date format setting would need to be "mm/dd/yyyy" and there can be no time in data. If there is, it gets a little more complex:
target_date = date#("12/01/2017");
count({$<IDField={"=floor(date)=$(target_date)"}>} [2])
I am not sure what u r asking but i am giving an eg in what i understand
Load * Inline [
ID,Name,Amount
1,A,100
1,A,100
2,B,200
2,B,200
2,B,200
2,B,200
2,B,200
3,c,300
4,d,400
5,e,500
6,f,600
];
Measure1:=Count( ID)
Measure2:==Count(ID)* Sum(Aggr(Count(ID),ID))