Как отобразить значение формулы из предыдущей записи в новую запись отчет Crystal
0
hi i want to show value of the previous record in new record
g1 = if {Mah.Mahf1} <> "" then (tonumber({Mah.Mahg1})/1000 ) * tonumber({Mah.Mahf1})
...
g2 = if {Mah.Mahf2} <> "" then (tonumber({Mah.Mahg2})/1000 ) * tonumber({Mah.Mahf2})
to g30
{Mah.Mahf1} is price
{Mah.Mahg1} is Weight
{Mah.Mah1} is name of the material
{Mah.MahName} is name of product
end price = tonumber({@g1})+tonumber({@g2})+tonumber({@g3})+tonumber({@g4})+tonumber({@g5})+tonumber({@g6})+tonumber({@g7})+tonumber({@g8})+tonumber({@g9})
+tonumber({@g10})+tonumber({@g11})+tonumber({@g12})+tonumber({@g13})+tonumber({@g14})+tonumber({@g15})+tonumber({@g16})+tonumber({@g17})+tonumber({@g18})+tonumber({@g19})+tonumber({@g20})+tonumber({@g21})+tonumber({@g22})
+tonumber({@g23})+tonumber({@g24})+tonumber({@g25})+tonumber({@g26})+tonumber({@g27})+tonumber({@g28})+tonumber({@g29})+tonumber({@g30})
<a href="https://i.stack.imgur.com/r2OJA.png">https://i.stack.imgur.com/r2OJA.png</a>[<a href="https://i.stack.imgur.com/r2OJA.png" target="_blank" title="New Window">^</a>]
Sometime there are several products
like the Picture below
<a href="https://i.stack.imgur.com/5FL55.png">https://i.stack.imgur.com/5FL55.png</a>[<a href="https://i.stack.imgur.com/5FL55.png" target="_blank" title="New Window">^</a>]
enter image description here
record 8 "gg" consisting of records 3 and 5 and must show "412,585" but show nothing
What should i do?
it's important please help!
Что я уже пробовал:
if {Mah.Mah1} = {Mah.MahName} then {@end price}
but show me you cant use findprice field into findprice