Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
i had solved by writing like this.
=sum(aggr(sum(DISTINCT {<CATEGORY={'D'}>}D.MAKING_SP),D.VOUCHER_NO,D.LABEL_NO))
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]))
i had solved by writing like this.
=sum(aggr(sum(DISTINCT {<CATEGORY={'D'}>}D.MAKING_SP),D.VOUCHER_NO,D.LABEL_NO))