I was designing a report and had multiple columns inside a table, e.g;
Column-A || Column-B
String 1 || 45000
String 2 ||
String 3 || 2000
Now, clearly as you can clearly see, on column-B we are supposed to perform SUM function. And this column contains one empty field. Also, I would like to mention here that table is being populated using "expression" and I am supposed to show sum of this column in separate textbox.
What I am already doing is; " =SUM(Fields.amount)" but that is not giving me correct answer.
I shall be thankful for any help.