-
- Posts: 309
- Joined: Tue Jul 12, 2016 4:47 pm
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.
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.
