topic Re: Set analysis, equal to another field in App Development

Set analysis, equal to another field

Anonymous — Thu, 30 Mar 2017 07:08:08 GMT

Hi!

I'm trying to sum "Budget_cost" for projects that in the same table have "Rev_no" equal to field called "Rev_no_actual" in another table.

I thought it would look like this but it doesn't work. I get 0,00 as result.

Sum({$<Rev_no={'Rev_no_actual'}>}Budget_cost)

Do anyone have any suggestion?

swuehl — Thu, 30 Mar 2017 15:08:39 GMT

Set analysis basically operates on field values, not on record level.

If you need a record based comparison, use

=Sum( If( Rev_no= Rev_no_actual ,Budget_cost))

If you want to speed up calculation, create a flag in the script, then use the flag in your set expression.

Anonymous — Fri, 31 Mar 2017 08:52:13 GMT

Excellent! Thanks!!