Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi experts,
would anyone know an expression that would give me the correct value for this calculation:
i have values in a table named "f_val". these are linked to their names in a table named "test". there are 8 names within the test table: a,b,c,d,e,f,g,h.
within the f_val table there are just numbers with decimal points. these two tables are linked by another table "f_sgrp" that has a unique identifier, e.g f_sgrp = 10001, so when that option is selected, all values and there tests that are entered under that sgrp are brought up.
what i need is the f_val from test table: a, b, ((based off of the matching f_sgrp) )add these together, there will be only 2 values due to matching f_sgrp. then have the resulting number in a new column in my straight table named "result".
any ideas?
thanks
can you share sample data