I would like to utilize the function field to perform the following calculations for a case and display them in a report.

[Community Alums]

I would like to utilize the function field to perform the following calculations for a case and display them in a report.

Number of records with 0 case reassignments/total number of cases x 100
How can we do this?

[JP - Kyndryl · Accepted solution]

Hi Nick,

You cannot use Function field for such calculation.

Function field is working only on each record.  So, let's say you have 2 in field A and 3 in field B,  you can add both values and store it in the Function field (so 5).

But it is not for aggregation calculation as you want.

For your calculation, you need PA (Performance Analytics).

Regards.

JP

[SR2]

Hello JP Plouffe - Kyndryl

,
Thanks for your valuable information. I have a small requirement regarding function field.

There are some operations like concat(), add(), dayofweek().

In the same way can we get a year from a date/time field and store in function field.

ex: the date is 2022-02-23, the value in the function field should be 2022.

Thanks.

[JP - Kyndryl]

Hi SR,

You cannot use a function field to get only the Year, since there is no available function for it.

You may create a new custom field u_year in your table and populate it with a BR having the following script:

(function executeRule(current, previous /*null when async*/) {

	var gdt = new GlideDateTime(current.u_custom_date.getDisplayValue());
	current.u_year = gdt.getYearLocalTime();

})(current, previous);

Where u_custom_date is your original date/time field and u_year is your new String type field.

Regards.

JP

[SR2]

Thank you JP Plouffe - Kyndryl for you reply,

I had achieved this through BR