FirstSortedValue Question

[jerryr125]

Hi and Happy 2021 !

I have a question regarding The FirstSortValue function.

I have the following Expression : 

Forecast Out of Stock Date:
=Date(FirstSortedValue(RTWCALENDARDATE, -Aggr( If(($(vForecastCTCBOHProductInvCalculcation)) > 0, -1E10, $(vForecastCTCBOHProductInvCalculcation)), RTWCALENDARDATE)),'MM/DD/YYYY')

And the following variable :

vForecastBOHProductInvCalculation

IF(Num#(Date(RTWCALENDARDATE,'YYYYMMDD'),'0') > $(vForecastDateStartNumeric),
($(vBOHProductInvsFinal))-aggr(Rangesum(Above((IF(Num#(Date(RTWCALENDARDATE,'YYYYMMDD'),'0') > $(vForecastDateStartNumeric),$(vForeCastProdTotal),$(vForeCastProdTotal))),0,RowNo())),RTWCALENDARDATE),
($(vBOHProductInvsFinal))-aggr(Rangesum(Above((IF(Num#(Date(RTWCALENDARDATE,'YYYYMMDD'),'0') > $(vForecastDateStartNumeric),$(vForeCastProdTotal),$(vForeCastProdTotal))),0,RowNo())),RTWCALENDARDATE))

Each of my locations has a  "Forecast Out of Stock Date".  I placed this in a table visualization with the name of the location.

The Forecast Out of Stock Date value does not appear in the table - only  when I filter on a specific location the expression shows the specific "Forecast Out of Stock Date" for the specific location (works perfect).

Any thoughts ? Jerry