Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]))
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)
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]))
Thanks Carly ...!!!