I am new to CC and have been try to work on syntax for calculations which I want to include into my reports. I am trying to create the following calculation on CC but have been struggling to develop the correct syntax.
STD check (%) = A2/A1 x W1/W2 * 100%
A1 = Average response of standard 1
A2 = Average response of standard 2
W1 = weight of standard 1
W2 = weight of standard 2
For this equation I have been able to create the syntax for the Average response of Std1 and Std2 using CC. I am not sure where I can place the weights of the standards, I have tried to place the weights of the standards on the sample amount column on the injection list in Data Analysis but I have not found a way use these values in my formula. I wanted to be able to reference the injection list in my formula because that is where I would like to report the masses or concentrations used, also because if I input the values directly onto my syntax I will have to change it every time I make a new standard. I was wondering if there was a way to use the injection list to do this or if there is a better way to do this.