Intersample Custom Field Empower 3

[EmpowersBane]

Hello,

I am looking for some help on how to calculate a particular custom field. I run 8 samples per batch, 6 batches per run, and I label the 8 samples U1 to U8. I need to add the Amounts for U7 and U8 for each batch so I do this via a custom field, Combined_Amount, as follows: U7.%.(Amount)+U8.%.(Amount) and as per the intersample syntax rules, this result isnt calculated until U8 sample is processed i.e. I only see the result for this CF at line U8 for each batch.

My dilemma is I need to calculate the amount of samples U1 to U7 as a percentage of this combined amount, so I tried coding a CF as:
U1.%.(Amount)/Combined_Amount*100. However, the result for this CF again is only visible on sample U8, as the rules of Empower processing state that calculations are only performed when all values are present ie when U7 and U8 have been processed. So when it comes to U1 to U7, Combined_Amount doesnt exist yet so the answer only populates on Line U8 when I want it to appear on lines U1 to U7.

In other words, at line U1, I want to see what the value for U1.%.(Amount)/Combined_Amount*100 is, at line U2, I want to see what the value for U2.%.(Amount)/Combined_Amount*100 is etc

Is this at all possible or am I resigned to only having all the values display at line U8? By the way I dont have All or Nothing ticked on any of the CFs, and I am still only seeing all the results on Line U8.

[anzalonm]

The current text comes from Gemini and I hope it can help you.

The solution is to use the SUM() function. This function can aggregate a value (like your Combined_Amount) across a batch and make that total available to all lines within that batch.
Here’s the two-step approach:
## Step 1: Your Original Combined_Amount CF
Keep the custom field you already created. This field will correctly calculate the total, but it will only display that total on the U8 line. This is perfectly fine, and we will use it as a building block.
CF Name: Combined_Amount
Formula: U7.%.(Amount) + U8.%.(Amount)
## Step 2: The New Percentage CF
Now, create your new custom field for the percentage. This one will divide the Amount from the current line by the sum of the Combined_Amount field for the whole batch.
CF Name: Percent_of_Combined (or any name you prefer)
Formula: (Amount / SUM(Combined_Amount)) * 100
Why This Works
Amount: This (without any prefix) refers to the Amount calculated for the current line (U1, U2, etc.).
Combined_Amount: This is the name of your first custom field.
SUM(Combined_Amount): This is the key. Empower will look at all the Combined_Amount values for the entire batch (your %. group). It will see:
U1: 0 (or null)
U2: 0 (or null)
...
U7: 0 (or null)
U8: [Your calculated U7+U8 total]
The SUM() of all these lines is simply your Combined_Amount total.
Crucially, Empower makes the result of a SUM() function available to all lines in the batch during processing.
So, when Empower processes line U1, it will calculate:
(U1's Amount / [U7+U8 Total]) * 100
When it processes line U2, it will calculate:
(U2's Amount / [U7+U8 Total]) * 100
...and so on for U3 through U7. This will give you the exact line-by-line percentage you're looking for, and the values will correctly appear on lines U1 through U7 (and U8 as well).