set analysis with multiple distinct

[venkat1]

getting error if i am writing an expression like below ,can anyone help me in writing an expression with multiple distinct fields .

=sum(Aggr(sum(DISTINCT{<CATEGORY={'D'},D.VOUCHER_NO,D.LABEL_NO>},D.MAKING_SP))

[mohamed_ahid]

Start by adding a  )  in the end .you are missing one  .

and the syntaxe is incorrect for the aggr function .it should be something like :

=sum(Aggr(sum(DISTINCT{<CATEGORY={'D'},D.VOUCHER_NO,D.LABEL_NO>}[what you need to sum]),[D.MAKING_SP]))

[venkat1 · Accepted solution]

i had solved by writing like this.

=sum(aggr(sum(DISTINCT {<CATEGORY={'D'}>}D.MAKING_SP),D.VOUCHER_NO,D.LABEL_NO))