1 Reply Latest reply on Feb 12, 2015 10:35 AM by RbnRbrts

    MonthName Calculation Result is always a number????

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