what's the frequency of the letter "e" in:
q: report: "sumif" within summary level formula i am looking to create a sort of customer retention report to essentially highlight accounts that did business within us in the past 1-2 years, but haven't since. specifically we want to identify these by key products and quantities, so i attempt to create this summary level formula, but unfortunately only get zero back even though i'm positive my product code is accurate
if(order_item_customer_prod_id="mykey",order_item_quantity:sum,0)
any ideas how i would achieve this or what i'm doing wrong with this current formula?

a: looking at the two most relevant help pages on this: (1) and (2), seeing your results and doing some extrapolation, it seems like the only usable fields in a summary level formula are summarized columns, not columns themselves. which is a pity.

user
In the text, there are 69 "e"s.
assistant