Not able to add a report for sum of a string field

[keval3]

HI All,

I have below requirement...

I am trying to develop a report to calculate the sum of a field which is created as a string field. When I tried to create a report it doesn't give me an option to select this field. IS there any other way to accomplish this? 

Thanks & Regards

KP

[AndersBGS]

Hi @keval3 ,

No, not through the report designer. Either you need to use a scripted automated indicator in performance analytics, or alternative you need to create e.g. a hidden field with a script to do the calculation and then populate the field. Based on the hidden field, you will be able to create the report through the report designer. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[keval3]

Hi Anders,

I am using normal report not a PA. so witch script I need to wright and where?

Thanks & Regards

KP

[AndersBGS]

Hi @keval3 ,

You can't utilize scripts in the report designer - it's not possible. As stated above, Either you need to use a scripted automated indicator in performance analytics, or alternative you need to create e.g. a hidden field with a script to do the calculation and then populate the field. Based on the hidden field, you will be able to create the report through the report designer. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders