Hi,
I'm creating a report in which I have used two formulas
@null & @sum
@sum formula= Sum ({uid}, {Command_2.agegroup}) + Sum ({other}, {Command_2.agegroup})
where uid other @sum
8 8 16
1
7 2 9
then I have used @null formula to get the null value
@null= if isnull ({other}) then
Sum ({other}, {Command_2.agegroup}) +
Sum ({uid}, {Command_2.agegroup})
else {@sum}
It gives me
uid other @null
8 8 16
1 1
7 2 9
Now I want the sum of @null column = "26"
I'm creating a report in which I have used two formulas
@null & @sum
@sum formula= Sum ({uid}, {Command_2.agegroup}) + Sum ({other}, {Command_2.agegroup})
where uid other @sum
8 8 16
1
7 2 9
then I have used @null formula to get the null value
@null= if isnull ({other}) then
Sum ({other}, {Command_2.agegroup}) +
Sum ({uid}, {Command_2.agegroup})
else {@sum}
It gives me
uid other @null
8 8 16
1 1
7 2 9
Now I want the sum of @null column = "26"