With reference to the screenshot, i want to create a text object that show the total of the last column, sum(fin_gl_line_reporting_amt)*if(sum(fin_gl_line_reporting_amt)>0,1,0) .
I can do this on a chart but not in a textbox.
I believe i need to make use of aggr function but i have no idea how to write the correct one.
Currently my formula is
but its not displaying anything, i wonder whats wrong. I have attached my qvw and excel data too.
Any help to simplify the whole formula or change it entirely is greatly appreciated.