Hi I would like to perform a calculation as follows. Thank you. Stress Test times output 0 Lot * Samples 0 500 Lot * Samples Test_Times [1] + Stress [2] 1000 Lot * Samples Test_Times [1+2] + Stress [3]

[Venkata Siva Komma]

I have readout and test time I would like to calculate output as shown in table.

which function do I have to use and how to transform the data

Thank you in advance.

[Gaia Paolini]

what happens if you have an extra row? Do you calculate it as Test_times [1+2+3]? In other words, how far back are you summing the Test_times column before the current row?

[Venkata Siva Komma]

Hi Gaia, Thank fo trying to understand my challenge. Here is detailed information.

I have a Unique sample and Experiment and I would like to know the final output in time how much time each sample is taking.

[Gaia Paolini]

Would this work?

Sum([testTime] + [readout]) over (Intersect(AllPrevious([readout]),[sample],[experiment]))

[Venkata Siva Komma]

Hi Gaia,

Fantastic. Its working. Thank you.

[Venkata Siva Komma]

Hi Gaia,

Function is working But again one more challenge. You see empty value I have in Readout so I expect empty value in Output as well.

I tried If and Null function However I could not figure it out. Can you please have a look into it. Thank you.

[Gaia Paolini]

can you elaborate on the rationale of the calculations? Since I am accumulating readouts, why would a null value at the end invalidate the whole output?

[Venkata Siva Komma]

Hi Gaia,

In Readout column I have three different read outs therefore I need output time also with respect to read out time. of course, I have to do accumulating for test time.

Therefore, I did follow. First, I accumulated and then added the readout now it's working

T1=Sum([Test time]) over (intersect([sample],AllPrevious([R_0])))

T2=T1+Readout

Thank you