Forum Discussion
safsad
Helper I
Helper IHow to find total hours without affecting the date selection?
Hi ,
I want to find the Sum of Hours from the Hours table, so what i'm looking for is to show the sum of Actual hours as i marked in the screen shot, but without the date filter. The date section shouldn't affect the "Actual Hours".
I really apprecaite any help provided.
This is the formula i used:
Actual Hours = SUM(hrs[hrs])+0
safsad , Do you need without any filter? Try
calculate(SUM(hrs[hrs]), all(Hrs))
2 Replies
- amitchandak
Super User
safsad , Do you need without any filter? Try
calculate(SUM(hrs[hrs]), all(Hrs))
safsadThanks Amit for the solution.
I got it by the following formula :
CALCULATE(SUM(hrs[hrs]),ALL(hrs[ddate]))