I would like to have a cell that contains summary value of child rows which have "rem" cell value == false.
Following function is obviously wrong:
sum( if( [../Relation1/rem] , 0 , [../Relation1/sum] ))
How can I choose which rows will be taken into calculation of sum?
Hello Arthur,
We are still following this forum thread.
Please feel free to let us know if you have any other questions with this matter.
Hi,
You can't do this with a single formula.
What I would do is add an unbound column to the grid and apply a formula to that unbound column something like this:
if ( [rem] == false(), [value], 0 )
Then you sum up the unbound column.