Solved

How to display blank or replace #value in Nintex forms

  • 14 September 2021
  • 2 replies
  • 98 views

Badge +5

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.

19648i6E2C39F52F56A818.png

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"))))

 

icon

Best answer by Aleximo 14 September 2021, 17:26

View original

2 replies

Badge +8

hey @ramanjjilunaidu ,


 


I would do it this way:


 


create a formular variable (for example varBlank) and enter ur formula:


 



 


now u go to ur calculated value field and enter following formula:


 


If(varBlank=="#Value!", "", varBlank)


 



 


that should do it.


Badge +5

Hello @Aleximo 


Excellent solution, appreciate your support.


Regards

Reply