Problem regarding Distinct function.

[#1]

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.)

[its_anandrjs]

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

[SunilChauhan]

use below

RangeSum(Top(Sum(Fieldname), 1, NoOfRows()))

hope this helps