Hello,
I have this exacte same problem described Calculate remaining time here but the documentation you have sent doesn’t answer the issue… I’m trying to get the total sum of all the remaining hours, with a Time dimension. Is there a calculated measure that could help ?
I have found this one on the documentation but it doesn’t work for me…
Best regards,
Thibault
Hello @Thibault
Thanks for posting your question!
The Community post you are referring to is a bit different. When checking the actual use case and looking at the report definition - we found different root cause. Without knowing what you have selected in your report/what other dimensions or measures you are using in your report, it is challenging to give you exact solution.
If your only goal is to sum all the Remaining hours regardless ofthe Time selected in your report you may consider defining a new calculated measure with the formula below.
If this still does not answer your question, please reach out to us directly, referring to this community post, sharing your report definition (Export and import report definitions) and a screenshot of the report showing the “incorrect” results, and, if possible - letting us know what the expected outcome should be.
(
[Measures].[Remaining estimated hours],
[Time].CurrentHierarchy.DefaultMember
)
Best wishes,
Elita from support@eazybi.com