Calculating Difference Between 2 Values

Q&A
,
1

Hi All

I’m trying to calculate the difference between two values (SLA Days and Days to EA) but keep getting errors.

image
image395×188 7.33 KB

Both values are also calculated fields (ifelse({SLA Type} = ‘CND28’, ‘28’, ifelse({SLA Type} = ‘Sub7’,‘7’,ifelse({SLA Type} = ‘GSF70’, ‘70’,ifelse({SLA Type} = ‘GSP45’,‘45’,‘N/A’)))) and dateDiff(dateinvestigationinitiated, actiondate, “DD”))

Any ideas?

Thanks

Alex

2

Hi @hopeah

Please remove the quotes from your result in SLA days calculated field. Instead of ‘28’ just have numeric value as 28.

Instead of N/A you need to have 0 or Null

Regards,
Giri

3

Perfect, thanks for that!