distinct sum not working

[vikasmahajan]

Dear all

I have following expression not giving  any result  i want to sum distinct for opening balance

SUM(DISTINCT{$<[Posting Date]={"<$(=min([Posting Date]))"} >} [INV_DOCPAYAMT])

Any one help me pls

Thanks

Vikas

[#2]

sum({<[Posting Date]={"<=$(=vMinDate)"} >} distinct [INV_DOCPAYAMT])

LET vMinDate = min([Posting Date])

Try to use this formula....

Hope this will  help you ! ! !

Regards,

Nitin Jain

[#3]

hi

try it.

sum({$<[Posting Date]={$(#=only([Posting Date])-1)},[Posting Date]=>}DISTINCT [INV_DOCPAYAMT])

hope this helps you.

[er_mohit]

use this expression hope it helps you

SUM( {$([Posting Date]={$(#=min(([Posting Date]))}>}DISTINCT [INV_DOCPAYAMT])