Portal calculation using "If" or "Case"

Discussion created by K.L on Jun 28, 2017
Latest reply on Jun 29, 2017 by beverly



I'm hoping someone can help. I have portal with the following fields: Qty, Item (Local and Labor).  I want a calculation that would give me the sum of of Qty, if the item is "local" and the sum of the Qty if the item is "labor". The calculation I used If (Item = "local"; sum(EstimateQty);0) only gives me the total sum of the Qty if the Local was listed in the first portal row.  This calculation would not check for any other "local" after the first row. I would like know how to write the calculation to check for all portal rows with the item = to local and the same to check for portal rows with the item = to labor.


Thank you in advance.