Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
hi
try it.
sum({$<[Posting Date]={$(#=only([Posting Date])-1)},[Posting Date]=>}DISTINCT [INV_DOCPAYAMT])
hope this helps you.
use this expression hope it helps you
SUM( {$([Posting Date]={$(#=min(([Posting Date]))}>}DISTINCT [INV_DOCPAYAMT])