http://forums.visokio.com/discussions/tagged/non-empty_count/feed.rss Mon, 30 Oct 17 17:53:49 -0400 Tagged with non-empty_count - Visokio Forums en-CA http://forums.visokio.com/discussion/2586/formulae-counting-records-by-months Tue, 10 Jun 2014 04:41:49 -0400 MattBoxall 2586@/discussions
I'm currently trying to put together a formulae field that will calculate the number of new cases opened (using a field with various dates noted) within the previous calander month. the difference is the core Excel data will be updated monthly and I want to have this automated rather than having to change the formulae field every month to reference a specific date.

I've tried using DATEADD and then an IF but I can't get recommended fomulae to work as GETDATE is not recognised. Any ideas how I can achieve this in Omniscope?

thanks,

Matt]]> http://forums.visokio.com/discussion/2295/aggregation-function-non-empty-counts Fri, 23 Aug 2013 05:36:37 -0400 Mees 2295@/discussions Is this expected behavior? Will be useful when this is possible.

Thanks, A]]> http://forums.visokio.com/discussion/1973/validate-data-proceed-only-if-minimum-number-of-rows-exists Wed, 09 Jan 2013 03:44:21 -0500 MartijnVisser 1973@/discussions
Best, Martijn]]>