isfirtstoccurrence formula

Hi, question please. I need to get the first data(#1), hence I used the isfirstoccurrence but not sure on why the #2,#133 and #362 are also checked in the boolean? Thank you. 




Best Answers

  • anirudh
    Answer ✓

    Isfirstoccurrence should be used to get the first line of unique data and not the first line itself. To get the first data do this instead:
    CUMULATE(1, #Entry) = 1


  • Along the same lines as what @anirudh was saying, use this formula:


    CUMULATE(1, FALSE, #Entry) = 1


    @anirudh missed the False