Skip to main content
Question

how to write a formel


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.

 

2 replies

nielsgerrits
VIP
Forum|alt.badge.img+55

You can put a conditional statement in the result.

conditional2018.fmwt


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

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings