sum set analysis for certain field value

[jasonseril]

Hello all,

I have a question on set analysis for finding the sum of "actual" value of all "H/Q" branch. Attached is the excel file of the data. Thanks in advance and have a good day.

regards,

Jason

[jasonseril · Accepted solution]

sorry guys, i got the answer already...

=Sum(IF(branch = 'H/Q',actual))

Thanks.

Jason

[#3]

jasonseril wrote:
sorry guys, i got the answer already...
=Sum(IF(branch = 'H/Q',actual))
Thanks.
Jason






 <div></div>

as per your request to use set analysis then use:

sum({<branch={'H/Q'}>} actual)

[jasonseril]

Thank you very much, dragonauta.