line item Percentage splits per unique ID

[David_Little]

How would I go about calculating the percentage split of totals for each unique ID ?

Example image below: The example input data is highlighted in yellow and what I'm after is in green.

Many thanks in advance !

[IraWatt]

Hey @David_Little,

There's probably a quicker way of achieving this but I would do it like this:

The Summery gets the overall total, then the append adds that as a row to each element which is then used in the formula to divide the amount by the total. 

If you have any questions on how this works make sure to ask :)

HTH,

Ira

[David_Little]

Hi @IraWatt I think that's a little different from what I'm after. It is not a percentage of the total column, it's a percentage of the total per ID.

So in your example, as there is only 1 unique ID per line, each line would be 1.00 (100% of the ID total)

[DataNath]

Think this is what you're after?

[binuacs]

@David_Little  or something like this?

[IraWatt]

Ah apologies @David_Little , I've adjusted the workflow:

Now the summary groups by ID 

[David_Little]

@DataNath  Jeez... That's so simple I cannot believe I didn't figure that out 😂 Many thanks !