Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to sum all shipped_qty where the organisation is not equal to 1020 and the curret period flag is equal 'Y'
=Sum({< CurrentPeriodFlag = {'Y'},{<ORGNAISATION-={'1020'}>} Invoice_Details.SHIPPED_QTY)
rajesh, I have used -= as '<>' was not working
Will this work?
Sum({< CurrentPeriodFlag = {'Y'}, ORGANIZATION-={'1020'}>} [Invoice_Details.SHIPPED_QTY])
Kind regards
André Gomes
could I sum shipped qty and ordered qty in the same expression?