Can someone help me figure out how to get the correct total of $ 123.17 on the summary table? How can I get the summary result? I have tried creating variables and using a combination of functions but no luck.
Detail
Project Call Qty Cost Amount
xxxxx 1234 16 $3.29 $52.60
------ --------- 10 $1.84 $18.41
------ --------- 2 $26.08 $52.16
------ ----- ----- Total $123.17
Summary
Project Call Amount
xxxxx 1234 $123.17