Passing null to functional maps

[jinkys]

Hi there

I want to run a functional map where I pass 5 values from fields created in the same card but above this field, my problem being that in4 and in5 can be NONE, but the functional map doesn't run with NULL inputs, I'm sure I've worked arounf this before but I cant remember for the life of me, does anyone have any ideas?

=XML_Announcement( In1, In2, In3, In4, In5)

 

[BocaBurger]

Possible solution. In the input type tree, set if none to be a 0. None and Null may not always be equivilent.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!

 

[eyetry]

You can also test for a null

=XML_Announcement( In1, In2, In3, either(In4,"dummy_value"), either(In5, "dummy_value"))

xml_announcement can teat 'dummy_value' as a null....

if (in4 = "dummy_value", do 'A', do 'B')