Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I came across the following set of data and I am confused how to actually calculate(write the expression)-
Account | Address | Structures | amount |
---|---|---|---|
abc | 143 east street | 2 | 1254 |
abc | 143 east street | 2 | 1257 |
abc | 143 east street | 2 | 45689 |
abc | 124 wing | 1 | 7895 |
abc | 124 wing | 1 | 475 |
abc | 124 wing | 1 | 3587 |
abc | 124 wing | 1 | 454 |
abc | 12 ertsd | 5 | 4585 |
abc | 12 ertsd | 5 | 75412 |
xyz | 134 hinjew | 1 | 4546 |
xyz | 134 hinjew | 1 | 58794 |
xyz | 134 hinjew | 1 | 451642 |
xyz | 85,E blue | 4 | 121 |
xyz | 85,E blue | 4 | 124578 |
I have a text object which should show total structures-
If account 'abc' is selected so total structures=2+1+5=8
How should i write the expression for this, need help.
Thanks
maybe, sum(distinct Structures) ?
One way is as below:
Hello Anas,
try
aggr(sum(Structures),Structures)
or
sum(aggr(Structures,Structures))
I'am not exactly shure which of both works
Hi,
The above example will work on selection.
But if you want it say on a chart
Use
=SUM(AGGR(ONLY(Structures),Address))
Mark
sum(distinct Structures) would do it; why complicate things?