What should be entered into a field if it is not needed when setting up a OneStream Excel function?

What should be entered into a field if it is not needed when setting up a OneStream Excel function?

• A. #
• B. %
• C. *
• D. ""

Answer: (D)

When configuring a OneStream Excel function, any field that isn’t needed should be passed as an empty string. This communicates that no value is provided for that parameter while preserving the expected string type the function expects. Using symbols like #, %, or * would carry other meanings (errors, formatting, or wildcards) and could cause the function to misinterpret the input or fail. Leaving the field blank isn’t always treated the same as explicitly signaling “no value,” so "" is the clear, safe way to indicate that the parameter is not used.

When configuring a OneStream Excel function, any field that isn’t needed should be passed as an empty string. This communicates that no value is provided for that parameter while preserving the expected string type the function expects. Using symbols like #, %, or * would carry other meanings (errors, formatting, or wildcards) and could cause the function to misinterpret the input or fail. Leaving the field blank isn’t always treated the same as explicitly signaling “no value,” so "" is the clear, safe way to indicate that the parameter is not used.