Hi there:
BACKGROUND:
I have data is a list of grants with organization name, grant amount, status of grant.
I have Beast Mode code:
SUM(SUM(requests_amount_recommended
) FIXED (BY organizations_id
FILTER ALLOW requests_granted
))
I think it works - the issue is that it is summing TOO much. Ideally, I want to edit this code so that requests_granted IS TRUE
or another way
not use "requests_granted" and instead use requests_state is "granted" or "closed"
Anybody know how to write that?