topic Re: Add N/A condition to a calculated field in App Development

Add N/A condition to a calculated field

Milaf — Thu, 29 Feb 2024 07:48:59 GMT

Hi everyone,

I am writing the following calculation to the KPI object and I multiplex this KPI object for each metric. When the user selects a team from the filter, the team's scores are displayed. Some metrics do not contain values for some teams and I want it to say 'N/A' for those KPIs.

AVG({<IS_SCORE={'1'}, [MetricName]={'Truncate'}>}AGGR(SUM(SCORE),[Team],[MetricId]))

I add if at the beginning of the formula and write N/A at the end of the parentheses for the case of 0, but this time it returns 0.00%.

What is the correct syntax?

Thank you.

Re: Add N/A condition to a calculated field

Antoine04 — Thu, 29 Feb 2024 07:53:35 GMT

Hello,

The syntax looks of for me.

Maybe you can try to use the Coalesce() function.

Maybe something like : Coalesce(Sum(Score),'N/A').

Hope it helps.

Regards

Antoine

Re: Add N/A condition to a calculated field

Milaf — Thu, 29 Feb 2024 12:21:38 GMT

Thank you for the quick solution, it is much more practical to write this instead of if.