Question

how to write a formel

terezia86
Badge

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
Rank
Userlevel 6
Badge +32

You can put a conditional statement in the result.

conditional2018.fmwt

D
Badge

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

Reply


Community Stats

28,707
Posts
109,479
Replies
36,552
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.