Shifting a Boolean line item

JadenVaught
JadenVaught
in Modeling

Hey, I am trying to make a boolean filter so you only see the columns with data plus x number of empty columns. So I have the Boolean Has Data? that is true if any line item has data.

image.png
image.png

So, what I want to see is the Display? Boolean to be true for the next 2 numbered list items.

Best Answer

  • shubhamrawat
    shubhamrawat
    Answer ✓

    Hi @JadenVaught

    This is an interesting question. I have tried solving it using the count concept and it works for the given scenario. Please find the module and formulas below. Please make sure your name list has a top level.

    count1.PNG
    count 2.PNG

    Formulas:

    count 3.PNG

    Hope this helps.

Categories