FirstSortedValue Question

jerryr125 — Fri, 02 Apr 2021 08:46:51 GMT

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

topic FirstSortedValue Question in App Development

FirstSortedValue Question