Skip to main content
Question

how to write a formel

  • July 8, 2019
  • 2 replies
  • 8 views

terezia86
Forum|alt.badge.img

hi,

how can I write in AttributeCreator iff the Value is missing than set Value to 0 ?

I have the created a form, see screenshot, and that is correct, but sometimes the Value of "_Anzahl_DT" is "missing" and then I do not get any Value in results..

I need to write in this form this case, that when Value of _Anzahl_DT is missing, than write 0 instead so the formel can count it with 0.

 

thanks.

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2939 replies
  • July 8, 2019

You can put a conditional statement in the result.

conditional2018.fmwt


Forum|alt.badge.img
  • 104 replies
  • July 8, 2019

Another tip is to clean up the data with a NullAttributeMapper before the AttributeCreator. Then you can map <missing> to 0.