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.

Accepted answers

anirudh

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

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

CUMULATE(1, FALSE, #Entry) = 1

@anirudh missed the False

All comments

anirudh

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

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

CUMULATE(1, FALSE, #Entry) = 1

@anirudh missed the False

DMManalili

thank you 🙂

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…