This content has been marked as final.
Show 3 replies

Re: pivot measure divide current sum for sales sum
Jerry Jackson Mar 17, 2018 11:26 AM (in response to Reporte Gestão)See if adding Total calculates the number you need:
if(isnull(Sum(CBL_ValorT)) or Sum(CBL_ValorT)=0, 0, num(fabs(Sum(CBL_ValorT))/Sum({<Group1={"0.*"}>}Total CBL_ValorT), '#.##0,0%'))

Re: pivot measure divide current sum for sales sum
Sunny Talwar Mar 18, 2018 7:55 AM (in response to Reporte Gestão)Or you might need to add your first dimension within the total qualifier
If(IsNull(Sum(CBL_ValorT)) or Sum(CBL_ValorT) = 0, 0, Num(fabs(Sum(CBL_ValorT))/Sum({<Group1={"0.*"}>}TOTAL <1stDimensionHere> CBL_ValorT), '#.##0,0%'))
Replace the 1stDimensionHere with the field name which contain RG because this will ensure that you divide by the 0. value of that particular 1st dimension....

Re: pivot measure divide current sum for sales sum
Reporte Gestão Mar 19, 2018 11:00 AM (in response to Sunny Talwar )Thank you, that really solve it. Now it presents the weight over the each shop sales.
