MonthName Calculation Result is always a number????
I have two identical databases; DB-1 and DB-2.
In DB-1, I specify a 'MonthName' calculation function to provide the result as a 'Number'. The output is as expected, a 'Number'. The report created from this DB-1 is as expected and looks great.
In DB-2, I specify the exact same calculation function with the result to be a 'Number'. The output, on the other hand, is 'Text'. No matter if the "Calculation Result is specified as a Text or a Number", the result is always 'Text'. The report created from this DB-1 is not at all what is expected.
I'm not sure what simple switch I haven't flipped to get the 'Number' result for the month as opposed to the 'Text'.
I am embarrassed to say that the error was in my calculation formula (pointing to the wrong field). Now that the correct field is being point to, all is AOK.