Hi, I am new to eazybi. I want to create a report where i have the sum of a custom field data in number for example at the end of the month the sum custom field number is 80.and the total working hours per month is let’s suppose 90. so, i can compare both numbers. But my question is from where I can get the total number of working hours in a month for example 1 working day have 8 hours and in month there is 25 working day, I should be 25*8. so, I can compare this number with the number enter in custom field.
Hello @Umar !
See this: Find total working days in a month
You may want to use DateDiffWorkdays() instead of DateDiffDays…
Let me know if it helps!
Hi @Umar !
Thanks @VasileS for the suggestion!
You can even go a step further and use the relatively new DateDiffWorkhours() function.
Use the Month level from the Time dimension in the Rows section of your report. Then define a new calculated measure in the Measures dimensions with a formula like this:
DateDiffWorkhours( [Time].CurrentHierarchyMember.StartDate, [Time].CurrentHierarchyMember.NextStartDate, '67','9-18' )
Let me know if this fits your use case or if you have any additional questions on this!
Nauris / eazyBI support