Dear All,

I want to display blank #value in Nintex forms calculated value.

I have a calculated value where i am displaying values based on other dropdown values. But here i don't select anything from dropdown value, it shows/displays as below.

I want to show blank instead #Value!

My formula is as below to display the calculated value based on other dropdown values.

If(Willthisprojectimpactavision== "Yes" || WillthisprojectimpactSEHAstrategy=="Yes" || WillthisprojectchangeaHCFsscope=="Yes" || Willthisprojectrequiresignificantbudget=="Yes", "Transformational Initiative",If(Doesthisprojectseektochangeorimproveaprocess== "Yes" || Doesthisprojectseektochangeorimproveanewprocess=="Yes" || Willthisprojectredesignaservice=="Yes" || Willthisprojectimproveasystem=="Yes" ||Willthisprojectcreateanewsystem=="Yes", "Quality Improvement Project",If(Doesthisprojectseektochangeaspecificstepinaprocess== "Yes" || Doesthisprojectseektosolvesmallproblem=="Yes", "Rapid improvement cycle",If(Doesthisprojectseektochangeorimproveaprocess== "No" || Doesthisprojectseektochangeorimproveanewprocess== "No" || Willthisprojectredesignaservice=="No" || Willthisprojectimproveasystem=="No" || Willthisprojectcreateanewsystem=="No" || Doesthisprojectseektochangeaspecificstepinaprocess=="No"||Doesthisprojectseektosolvesmallproblem=="No"|| Willthisprojectimpactavision=="No"||WillthisprojectimpactSEHAstrategy=="No"|| WillthisprojectchangeaHCFsscope=="No"|| Willthisprojectrequiresignificantbudget=="No", "Other"))))