TABULUS^®, The Table Oriented Spreadsheet

TABULUS^® 2010 - Simply put, TABULUS is a better spreadsheet!

home	recent topics	recent posts	search	faq

pages: 1
11/10/2009 2:16:54 PM chrisdrost Posts: 9	Currently the Category Operators do not work with Calendar Items. How can I write a formula that only calculates in the Month of December?
11/10/2009 2:16:54 PM chrisdrost Posts: 9	permalink
11/12/2009 1:29:10 AM rado Posts: 47	If you want to write a formula which is sensitive to the month, you using this to find the current month: "= if ( Month ( GetItemDate ( ) ) = 1 ; "Is Jan" ; "Is other month" )" With the current version, we cannot set a scope to each January, for example. I would have to have a separate formula for each January. This will be in a future version. -- Radoslav Nemchev CTO, Diehl Technology LLC
11/12/2009 1:29:10 AM rado Posts: 47	permalink
4/20/2010 8:34:01 AM rado Posts: 47	This feature is implemented in TABULUS 2010 SP1. You can define formula scope as shown: (formula calculates only in November and December of 2005, 2006 and 2007) edited by rado on 4/20/2010 -- Radoslav Nemchev CTO, Diehl Technology LLC Attachments: image1[1].jpg
4/20/2010 8:34:01 AM rado Posts: 47	permalink