QTY on Hand by Location Formula

Add SiteID to the join between INLocation and INLocationStatus. INLocation.LocationCD is the selection and both have LocationID as part of the key.

INLocation to INLocationStatus on LocationID = LocationID and SiteID = SiteID.

I added that, but still with no luck. I have come up with a solution: 

1. Each location CD shows a numerical value in the DAC schema browser. For us, CONTAINER1 = 4127
2. =IIF([INLocationStatus.LocationID]=4127,[INLocationStatus.QtyActual],0)
3. This works, but shows actual instead of on hand...I am still working out the on-hand formula

Then in your condition, specify the location you want to view or make it a parameter for flexibilty

And the Resulst

Then in your condition, specify the location you want to view or make it a parameter for flexibilty

And the Resulst

 

Yes, this is how I have it setup, however, I am going for multiple columns with multiple locations. I have created this so far and it seems to be working: 

I have now created and tested the formula to show the additions of all the offsite locations: 

=Sum(IIF([INLocationStatus.LocationID]=4127 OR [INLocationStatus.LocationID]=4128 OR [INLocationStatus.LocationID]=4129 OR [INLocationStatus.LocationID]=4130 OR [INLocationStatus.LocationID]=4131, [INLocationStatus.QtyActual], 0))

I would like the row to turn red if the formula above is less than SO booked. I tried the formulas below, with no success, any ideas? 

=IIF([INSiteStatus.QtySOBooked] > Sum(IIF([INLocationStatus.LocationID] IN (4127, 4128, 4129, 4130, 4131), [INLocationStatus.QtyActual], 0)), 'red', 'default')

and

=Sum(IIF([INLocationStatus.LocationID]=4127 OR [INLocationStatus.LocationID]=4128 OR [INLocationStatus.LocationID]=4129 OR [INLocationStatus.LocationID]=4130 OR [INLocationStatus.LocationID]=4131, [INLocationStatus.QtyActual], 0)) >[INSiteStatus.QtySOBooked], 'red', 'default')