isfirtstoccurrence formula

Highlighted
Contributor

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. 

 

DMManalili_0-1603458591412.png

 

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: isfirtstoccurrence formula

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

Regards,
Anirudh

Highlighted
Master Anaplanner/Community Boss

Re: isfirtstoccurrence formula

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

 

CUMULATE(1, FALSE, #Entry) = 1

 

@anirudh missed the False

Highlighted
Contributor

Re: isfirtstoccurrence formula

thank you 🙂