Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all!
I am struggling with the next, I have an output from
=
aggr(
Min(
{<
$(v_SA_Forecast_A) ,
COUNTRYCODE = {$(vFilterCountryCode)},
FLEETNAME = {$(vFilterFleetName)}
>}
EXPECTEDSALESYEAR), EXPECTEDSALESYEAR)
That returns perfectly the years. But I want to have the combined distinct values from the next set where only my filter is now Forecast_B instead of A. So in fact, I want to combine the two outputs and ofcourse only see the distinct values. A tried a lot but can't work it out. Any suggestions?
Thanks!
Shoot! It worked with the '+', thanks!
Hi @Remco , maybe you need to do an intersection of data sets resulting from set analysis. Check the documentation about it
* | Intersection. This binary operation returns a set consisting of the records that belong to both of the two set operands. |
example :
=
aggr(
Min(
{
<
$(v_SA_Forecast_A) ,
COUNTRYCODE = {$(vFilterCountryCode)},
FLEETNAME = {$(vFilterFleetName)}
>
*
<
$(v_SA_Forecast_B) ,
COUNTRYCODE = {$(vFilterCountryCode)},
FLEETNAME = {$(vFilterFleetName)}
>
}
EXPECTEDSALESYEAR), EXPECTEDSALESYEAR)
Thanks Fabian, I will check the source. For the moment the example does not work, no values returned.
Shoot! It worked with the '+', thanks!