ramanjjilunaidu
Forms Fledgling

How to display blank or replace #value in Nintex forms

Jump to solution

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.

ramanjjilunaidu_0-1631609836101.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"))))

 

0 Kudos
Reply
2 Replies
Aleximo
Cloud Wanderer

Re: How to display blank or replace #value in Nintex forms

Jump to solution

hey @ramanjjilunaidu ,

 

I would do it this way:

 

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

 

Aleximo_0-1631633043025.png

 

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

 

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

 

Aleximo_2-1631633217726.png

 

that should do it.

View solution in original post

0 Kudos
Reply
ramanjjilunaidu
Forms Fledgling

Re: How to display blank or replace #value in Nintex forms

Jump to solution

Hello @Aleximo 

Excellent solution, appreciate your support.

Regards

0 Kudos
Reply