Skip to main content

Good day,

 

Please help, I have calculated columns on Nintex form 2019 and they are displaying #Value! on an item, some items show correctly and some show the “#Value!” error, I have tries to rewrite the formulas it did not work out, the user enters the correct information on the form however its like the form decides to display the #Value! and it just picks items because some items display the results correctly.

I am not sure where the issue is.

Can you provide additional information? 

What is the formula?

Can you share some user inputs where it’s working as intended and some user input that appears to be correct but is failing? 

Without these things it’s impossible to help

Thank you. 


Hi @MegaJerk 

Here is the formula: formatDate(If(PCBStructureFinish&&isNullOrEmpty(PCB Structure Finish Date), Current DatePCB Structure Finish Date),"dd/MM/yyyy")

 

Below is what is shows on the form instead of a date.

 

And below is when its working fine.

 


Can you share the actual values of each of those Controls (give me the name “PCBStructureFinish” and the Value)? 

Please do this for each control listed in your formula and provide both values for when your calculated formula works, and for when it doesn’t. 


Reply