Can I have a sumif from a repeat?

Question

so I have a repeat that contains

select_one donationdonation_listselect_one donation_itemdonated_typetextdonated_item_sizeintegeritem_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

TomReyes · Answer

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.

Anonymous User · Answer

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

if food calculate repeat.xlsx

Anonymous User · Answer

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.