Use of Set Analysis, Month Function In Straight Table

cpiocpio — Wed, 19 Feb 2014 22:10:28 GMT

Used the well known wizard to create the set analy

// ---------------------------------------------------------------------

// Calculate the Sum of "calDueDate"

// based on all values

// ~~

// but before calculating

// - Select records in field "Month(calDueDate)" matching the condition: [equal to "Month(Today())"]

// ~~~~

// ---------------------------------------------------------------------

=Sum({1<Month(calDueDate)={$(=Month(Today()))}>}calDueDate)

However using in my chart does not return any data

Other values in use in the same chart work but I am specifying the item in those case for example :

Sum({1 <DueDateFinYear = {'2012/13'}>} i_lifts) ---- Different field of course

Re: Use of Set Analysis, Month Function In Straight Table

cpiocpio — Thu, 20 Feb 2014 06:54:48 GMT

IGNORE THIS POST, I duplicated posting