Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have the following expression and I would like to ignore year when filter is on, however I'm not getting any or incorrect data.
Currently:
=num(Sum({<Role = {'RoleA'}>}Aggr([Hours_RoleA],Field1,Field2,Field3,Field4)),'#.##0')
What I thought would work but didnt.
=num(Sum({<Role = {'RoleA'},Year=>}Aggr([Hours_RoleA],Field1,Field2,Field3,Field4)),'#.##0')
Do you guys have any idea?
Thanks in advance.
You need to include the ignoring of year-selections within the aggr too, maybe with:
=num(Sum({<Role = {'RoleA'},Year=>}Aggr(only({< Year= >} [Hours_RoleA]),Field1,Field2,Field3,Field4)),'#.##0')
- Marcus
You need to include the ignoring of year-selections within the aggr too, maybe with:
=num(Sum({<Role = {'RoleA'},Year=>}Aggr(only({< Year= >} [Hours_RoleA]),Field1,Field2,Field3,Field4)),'#.##0')
- Marcus
You might need to add the set analysis condition also to your second count but you couldn't just replace the if-part because your count-expressions are different (the distinct statement).
- Marcus