How to display the value of a formula in the previous record in the new record crystal report

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