Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What I would like to do if possible is to get the sum total minus value and the sum total possitive value from a column in the table
the expression for the field is
=num((aggr(sum(TOTQTY),PART_NUMBER) -aggr(sum({<[HM000_WAREHOUSE]={1}>}[HM000_MOHTQ]),PART_NUMBER,[LOCATIONS-SYNONM],Planner))*[Standard Cost],'£#,##0.00;-£#,##0.00')
any help would be greatly appreciated
Hi Eaun,
The reason why this is not working, is because you are creating two arrays and subtracting them from each other. Try to put a sum around the aggrs:
=num(Sum(aggr(sum(TOTQTY),PART_NUMBER)) - Sum(aggr(sum({<[HM000_WAREHOUSE]={1}>}[HM000_MOHTQ]),PART_NUMBER,[LOCATIONS-SYNONM],Planner))*[Standard Cost],'£#,##0.00;-£#,##0.00')
Jordy
Climber
Hi Eaun,
The reason why this is not working, is because you are creating two arrays and subtracting them from each other. Try to put a sum around the aggrs:
=num(Sum(aggr(sum(TOTQTY),PART_NUMBER)) - Sum(aggr(sum({<[HM000_WAREHOUSE]={1}>}[HM000_MOHTQ]),PART_NUMBER,[LOCATIONS-SYNONM],Planner))*[Standard Cost],'£#,##0.00;-£#,##0.00')
Jordy
Climber
Thanks that worked