Can I have a sumif from a repeat?

589
4
01-07-2018 07:10 AM
WaleedAl_Bukhari1
New Contributor

so I have a repeat that contains 

select_one donationdonation_list
select_one donation_itemdonated_type
textdonated_item_size
integeritem_count

so what I need is sumif(${donated_type}='Food', item_count)

I need  the total of (item_count) when the donation type is 'food'

is that possible

0 Kudos
4 Replies
DanPatterson_Retired
MVP Esteemed Contributor
Philip-Wilson
Esri Notable Contributor

Waleed,

Currently we do not support sumif or calculations across repeats for multiple questions, only what is supported by the documentation Dan mentions above.

Phil.

TomReyes
New Contributor

Hello, I just wanted to check in and see if ESRI supports this now or will soon now that it has been almost 4 years since this question was originally posed.

0 Kudos
DamienHoffman
New Contributor III

If you are flexible...the next best thing?  It adds two fields but gets the results you are looking for.