how to handle No value using Smart value for date field

Peyush Agarwal_1dgyi8

So I have used Difference function to find value between 2 dates. Now in order to do error handling, if in case one of the date is missing, it starts throwing out. 

{{#=}}ROUND ((({{QA Ready - Planned.diff(QA Ready - Actual).days}} / {{Implementation Start.diff(QA Ready - Planned).days}}) * 100), 2){{/}} %

 

I have been able to use generally as : 

{{QA Actual Effort - till CQA}}{{^QA Actual Effort - till CQA}}0{{/}}

 

but unable to understand how to use along with difference function 

{{#=}}ROUND ((({{QA Ready - Planned.diff(QA Ready - Actual).days}} / {{Implementation Start.diff(QA Ready - Planned).days}}) * 100), 2){{/}} %

Please suggest 

Bill Sheboy

Hi @Peyush Agarwal 

I had a similar issue with numeric values, and because smart values cannot be nested the default value feature didn't support also working with functions (such as diff).

The only work-around I found was to use IF conditions prior to my math, ensuring that all values were available or initialized prior to use.

Best regards,

Bill