isfirtstoccurrence formula

DMManalili
Frequent 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

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
anirudh
Community Boss

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

View solution in original post

rob_marshall
Moderator

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

 

CUMULATE(1, FALSE, #Entry) = 1

 

@anirudh missed the False

View solution in original post

3 REPLIES 3
anirudh
Community Boss

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

rob_marshall
Moderator

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

 

CUMULATE(1, FALSE, #Entry) = 1

 

@anirudh missed the False

DMManalili
Frequent Contributor

thank you 🙂