Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Excellent! Thanks!!