Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a scenario where i need to calculate MTD and YTD hoursworked of a an individual. I am getting the total right but in the straight table I am not getting the desired output.
I have got this output
Date | Name | Hours | StartTime | EndTime | Vendor | Work_type | Class | Job Description | MTD | YTD |
---|---|---|---|---|---|---|---|---|---|---|
13.9 | 13.9 | |||||||||
2017-01-01 | Adam Newman | 6.9 | 01-01-2017 07:01:00 | 01-01-2017 13:55:00 | PLANT ENGINEERING CONSTRUCTION PTE | Contracator | DIRECT | FORMAN - FOREMAN | 6.9 | 6.9 |
2017-01-02 | Adam Newman | 0.2 | 02-01-2017 17:45:00 | 02-01-2017 18:00:00 | PLANT ENGINEERING CONSTRUCTION PTE | Contracator | DIRECT | FORMAN - FOREMAN | 0.2 | 0.2 |
2017-01-03 | Adam Newman | 6.8 | 03-01-2017 07:01:00 | 03-01-2017 13:54:00 | PLANT ENGINEERING CONSTRUCTION PTE | Contracator | DIRECT | FORMAN - FOREMAN | 6.8 | 6.8 |
But i need something like this:
Date | Name | Hours | StartTime | EndTime | Vendor | Work_type | Class | Job Description | MTD | YTD |
---|---|---|---|---|---|---|---|---|---|---|
13.9 | 13.9 | |||||||||
2017-01-01 | Adam Newman | 6.9 | 01-01-2017 07:01:00 | 01-01-2017 13:55:00 | PLANT ENGINEERING CONSTRUCTION PTE | Contracator | DIRECT | FORMAN - FOREMAN | 6.9 | 6.9 |
2017-01-02 | Adam Newman | 0.2 | 02-01-2017 17:45:00 | 02-01-2017 18:00:00 | PLANT ENGINEERING CONSTRUCTION PTE | Contracator | DIRECT | FORMAN - FOREMAN | 7.1 | 7.1 |
2017-01-03 | Adam Newman | 6.8 | 03-01-2017 07:01:00 | 03-01-2017 13:54:00 | PLANT ENGINEERING CONSTRUCTION PTE | Contracator | DIRECT | FORMAN - FOREMAN | 13.9 | 13.1 |
The Exptression which i am using is : =SUM({<date_num={">=$(vMTD_Start)<=$(vMTD_End)"}>}Hours)
Tried the rangesum function but its not working.
Any help would be appreciated.
Which chart is this, We have option called Full Accumulation ?
This should work if your original expression worked
=RangeSum(Above(TOTAL SUM({<date_num={">=$(vMTD_Start)<=$(vMTD_End)"}>}Hours), 0, RowNo(TOTAL)))
or use the full accumulation on the expression tab of chart properties (only available for straight table)
Or
Rangesum(Below(SUM({<date_num={">=$(vMTD_Start)<=$(vMTD_End)"}>}Hours),0),Above(Hours,1,1000))