Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Expression for count of Concern Id:
Count({<SaleMarker = {1}, DDiff_C = {0}>}ConcernID)
Expression for count of transactions:
Count({<SaleMarker = {1}, DDiff_T = {0}>}TransactionNo)
I need to set an expression to work out the percentage of concerns against transactions.
Can someone kindly put this together for me as the set analysis brackets are throwing me!
Thanks
Maybe just divide both expressions:
Count({<SaleMarker = {1}, DDiff_C = {0}>}ConcernID) / Count({<SaleMarker = {1}, DDiff_T = {0}>}TransactionNo)
Just missing extra brackets - thanks
=(Count({<SaleMarker = {1}, DDiff_C = {0}>}ConcernID) / Count({<SaleMarker = {1}, DDiff_T = {0}>}TransactionNo))*100