http://forums.visokio.com/discussions/tagged/durations/feed.rss Mon, 30 Oct 17 16:45:35 -0400 Tagged with durations - Visokio Forums en-CA http://forums.visokio.com/discussion/2673/datetime-calculating-and-comparing-durationss Tue, 05 Aug 2014 11:27:44 -0400 chrisamott 2673@/discussions
I have used the DateDiff function to calculate the difference between Start and End but it produces a decimal number. I have tried many different formulae and reformatting measures to compare the Time Period with my calcualtion but they all fail.

Either Omniscope cannot parse the decimal or it doesn't recognise the time to convert it to text. I can easily paste the Time Period into Excel and reformat as a general number and it produces a decimal that compares favourably with my DateDiff but I need to do this in Omniscope.]]>