hi all,

Now i'm not sure which category this post falls under but if i didn't have to work with portals i wouldn't post this

Four calculation fields in a portal Products::Quantity/ Products2::Price/ Products::Total/ Products::GrandTotal

Products::Quantity * Products2::Price = Total (works fine)

Sum(Products::Total) = Grand Total (not working)

Grand Total only displays the first portal row sum. What am i doing wrong?

Thanxs for any help.

What files and relations you have?

to lazy to type out relations

added picture

Archive.zip

In which table is Grand Total defined? It doesn't make any sense if it is in the Products table. If it is in the Data Entry table, then it makes sense but will naturally have a single value for each portal, which means you will want to put it outside of the portal.