Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
Can anyone tell me how can i express in set analysis "sum distinct".
How can i put the command distinct or how can i have distinct results of sum sales in the below expression.
sum( {<DATE={ '$(=vdate)' } > }sales)
Thank you in advance.
sum( {<DATE={ '$(=vdate)' } > }Distinct sales)
or
if vdate is variable
sum( {<DATE={ '$(vdate)' } > }Distinct sales)
sum( {<DATE={ '$(=vdate)' } > }Distinct sales)
or
if vdate is variable
sum( {<DATE={ '$(vdate)' } > }Distinct sales)
try this
sum( {<DATE={ '$(=vdate)' } > } Distinct sales)