Calculated column in Attribute view

[former_member681145]

Hello Team,

I am creating a calculated column and found some error with respect to data type,  the Quarter values  I should get as Q1,Q2,Q3 and Q4.

I have selected data type is VARCHAR -Can you just guide me on this...

Error message is:

Short Text

  Attribute type is not valid

Cause

  Mismatch between data type defined and values computed.

Recommendations

  Check calculated measure/attribute definition and ensure data types match.

[former_member182302]

Hi Rishikesh,

What is the data type for QTR?  if it is not string you should first convert it to a string and then use it.

'Q'+ string ( QTR)

Regards,

Krishna Tangudu