Joined: 19 Nov 2013
Online Status: Offline
Posts: 23
Topic: Null Formula Posted: 04 Aug 2016 at 9:09am
I have a field that will print a part # but if no part number is there it leaves it blank. I'm not sure if I am just having a bad day but, when I put this formula in:
If IsNull({Part}) Then "Material
Hardware" Else {Part}
it gives me all lines with Material Hardware not just the blank ones??
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 04 Aug 2016 at 10:04am
Do you have your formula expert set to Default Values for Nulls. Also if {Part} is string, I seem to have better success with If len({Part}) = 0 The 'Material Hardware' else {Part}
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
