How to get Range of Values between two Booleans that are time formatted?

jhondoe443322
jhondoe443322
in Modeling

When the user select Two Boolean Check the range is defined so I want to get the range of values respective months.

Screenshot 2024-02-29 082304.png
Screenshot 2024-02-29 083151.png

Tagged:

Best Answers

  • Amaya
    Amaya
    Answer ✓

    Hello

    This is an example. How do you like it?

    image.png

    Cumulate = Previous(Cumulate) + CHK Count

    Taichi

  • Amaya
    Amaya
    Answer ✓
    image.png

    I hope this helps

Answers

  • jhondoe443322
    jhondoe443322

    What's the Formula for Count Cumulate?

  • jhondoe443322
    jhondoe443322
    edited February 29

    But I want the Range only when two booleans are selected! @Amaya the count cumulate is getting values when one boolean is selected which is the factor that is driving Between? Boolean.

  • sobaid
    sobaid
    edited March 1

    Hi You may need Two Line items specifying From and To months boolean selection, and then using previous and next functions in intermediate line items you can arrive at final line item filter upon which you can fetch the required values saying IF Final then Amount else 0.
    Additionally you can use system module to drive From and To selections using Time dropdown(Date) and tweaking From and To logic like START() = 'SYS07 Include Sleection'.Start Date
    Module View:

    image.png

    Blueprint View:

    image.png

Categories