AnsweredAssumed Answered

MonthName Calculation Result is always a number????

Question asked by RbnRbrts on Feb 12, 2015
Latest reply on Feb 12, 2015 by RbnRbrts

Title

MonthName Calculation Result is always a number????

Post

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'.

Outcomes