Forum Discussion
Wrong difference in Hours From Two dates
AndreaPRJ maybe dumb question, but given these are calculated columns and you're pulling them into a visual, what is the aggregation you have set on the "Difference in HH" column? (sum, average, do not summarize, etc.)
And, relatedly, are "actualstart" and "actualend" unique?
What I'm getting at here, is could those values you're seeing in "Difference in HH" actually be the sum of numerous records...
AndreaPRJ maybe dumb question, but given these are calculated columns and you're pulling them into a visual, what is the aggregation you have set on the "Difference in HH" column? (sum, average, do not summarize, etc.)
And, relatedly, are "actualstart" and "actualend" unique?
What I'm getting at here, is could those values you're seeing in "Difference in HH" actually be the sum of numerous records...
the question was not stupid ... it was a trivial mistake and I thank you!
It's Friday, I need a rest 🙂 bye!