Last Occurence

PujithaB
PujithaB
in Modeling

If line item is list formatted and if list item choosen is repeating , then how to get the last ocurrence of every list item?

Tagged:

Best Answer

  • ArunManickam
    ArunManickam
    Answer ✓

    Input Module

    ArunManickam_0-1582129512075.png

     

    Calculation

    ArunManickam_1-1582129562258.png

     

    Note: Summary for this line item is kept as "last non-blank"

     

    The last occurence is indicated in the summary row.

     

    Thanks

    Arun

     

     

Answers

  • Misbah
    Misbah

    @PujithaB 

     

    Can you please post some snapshots of what are you trying to achieve. We don't have native ISLASTOCCURENCE functionality , the closest we have is LastNonBlank - as an aggregation functionality and you can also change the summary settings of a line item to Last Non Blank - Explore these options and see if this helps

     

    If not, feel free to post a snip here about the expected outcome - will surely try to help

     

    Thanks,

    Misbah

  • Amaya
    Amaya

    Hi, @PujithaB 

     

    I suppose that you mean like this, don't you?

    I set three modules.

     

    1. Choose from List

    -- dimension: numbered list (#1-20), Line item 'Choice' formatted as the List Item Choice(A-D)

     

    2. Process

    -- dimension: numbered list(#1-20) & Choice(A-D)

    Line Item 'Which' is described below

    numbered list has build-in top level and its summary method set as 'Lastnonblank'

     

    3. What is the last row

    -- dimension: Choice(A-D)

    Line Item 'the last row' = process.which

     

    LastOcurrence.png

     

    I hope this works in your model.

     

    Regards,

    Taichi

Categories