This content has been marked as final.
Show 1 reply
-
1. Re: Hoping for help - calculation on data from multiple sources
Tracy RodgersJun 27, 2012 2:45 PM (in response to Laura Seay)
Hi Laura,
This is because grand totals are not necessarily a sum of whatever is in the view, rather they use whatever aggregation is on the measure. So since the output of the calculation was to be either 1 or 0, the result was 1 because the total sum of Scheduled Date Conversion was greater than the Anesthesia Start Time Conversion. One way to get the desired result is to calculate the desired outcome and place it on a separate worksheet, then place these two sheets on a dashboard together.
Hope this helps a bit!
-Tracy