Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Distinct is a easy function to use but my problem is that
when I use it in a straight table expression inside a sum
function the total is comming smaller,because the distinct
eleminates duplicate value in to one value.But I need to show
the actual total.
How to resolve it?Please help me.I am waiting for your first respone.
Thanks & Regards,
Koushik Roy.
(GreenCube Infotech.)
Hi,
You have to sum some think like below
Sum( Distinct If( isnull( Yourfield ) = -1,1,0 ) ) + Sum( Distinct Yourfield )
try this
Let me know
HTH
Rgds
Anand
use below
RangeSum(Top(Sum(Fieldname), 1, NoOfRows()))
hope this helps