Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following measure:
=Sum((Principal/TotalGrossSquareFootage)*Principal)/Sum(Principal)
The (Principal/TotalGrossSquareFootage) portion is the loan per sq ft, which I want to weight.
At the record level, Sum((Principal/TotalGrossSquareFootage)*Principal)/Sum(Principal) works as expected, but the weighting amount at the summary level is incorrect and when I filter the summary is incorrect.
In addition, I do not want to include zeros in my weighting. I did not address that above because I do not have the weighting working correctly.
This is a filter for one loan:
The weighted summary should be 60.19, not 180.57.
And the one below should be about 106, not 481.41.
I cannot figure out what I am doing wrong.
I solved my issue. I replaced Principal in =Sum((Principal/TotalGrossSquareFootage)*Principal)/Sum(Principal)
With Principal*(LeasedPropertySqFt/
if(Alt(TotalGrossSquareFootage,0)=0,GrossSquareFootage,TotalGrossSquareFootage))
This did the trick.
I solved my issue. I replaced Principal in =Sum((Principal/TotalGrossSquareFootage)*Principal)/Sum(Principal)
With Principal*(LeasedPropertySqFt/
if(Alt(TotalGrossSquareFootage,0)=0,GrossSquareFootage,TotalGrossSquareFootage))
This did the trick.