How to get sum of rows value of straight table into a text object

[chandan3535]

Dear All,

I want to use sum of rows value which i have computed in straight table into text object, but i am not getting the same value in a text object, it is showing me the total expression value.

Please note i want to show only those value in a text object whose total outstanding amount is not Zero.

Attaching my QVW.

Any help would be greatly appreciated.

[#2]

Hi Chandan ,

The Document Type MR having the value (2000 , 2000 , 1000) , Thats why its showing the result 5000 .

use the below expression in text box to get the result as 2000

=if(Sum(Aggr(sum({<Posting_Date={"<=$(=max(Date))"}>}[Outstanding Amount]),[Customer No]))<>0,

max({<[Document Type]={'MR'},Posting_Date={"<=$(=max(Date))"} >}[Outstanding Amount]),0)

[#3 · Accepted solution]

You put your aggr around the whole equation:

=sum(Aggr(if(sum({<Posting_Date={"<=$(=max(Date))"}>}[Outstanding Amount])<>0,

sum({<[Document Type]={'MR'},Posting_Date={"<=$(=max(Date))"} >}[Outstanding Amount]),0), [Customer No]))

[chandan3535]

Thanks Carly ...!!!