0

DIVISION WITH NULL OR ZERO COLUMN

I'm trying to do a split between "column A and column B", but column B has null and zero values. 

I also need to create a year filter, referring to these values. But I can not. 

Can someone help me?

1 comment

  • 0
    Avatar
    Meggan King

    Hello! 

    Thank you for posting in the community. In order to help us understand what you are trying to do and what "split" between Column A and Column B means, please send a message to the support team support@klipfolio.com

    It does appear your year filter is sparse, so any value without a year would be excluded when filtering - if this is expected that is fine, but if that is not expected, then putting in values for missing years or a place holder will be necessary. You would use a userinput control along with a variable to filter the formula based on the users selection. 

    Thank you

    Meggan

Please sign in to leave a comment.