Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
how to make this chart show only data from mandate 300?
I don't want to select a list box like this
this is my code:
num(
(
sum(aggr(SUM({<ML_Ort.LagerOrt={2000},S_Artikel.Firma={300,310}>} MLA_OnHand.OnHand)
*avg({<ML_Ort.LagerOrt={2000}>} c_LagerBestand.c_Dpr/c_LagerBestand.xc_Kurs),MLA_OnHand.Part))
+
sum(aggr(SUM({<ML_Ort.LagerOrt={2000},S_Artikel.Firma-={300,310}>} MLA_OnHand.OnHand)
*avg({<ML_Ort.LagerOrt={2000}>}c_LagerBestand.c_Dpr),MLA_OnHand.Part))
)
/
(
(sum(aggr(SUM({<S_Artikel.Firma-={'300','310'},ML_Ort.LagerOrt={2000}>}
MLL_Movements.Quantity *MLL_Movements.c_Dpr),MLL_Movements.Documentnumber)) * -1 )
+
(sum(aggr(SUM(
MLL_Movements.Quantity *MLL_Movements.c_Dpr / MLL_Movements.xc_Kurs),MLL_Movements.Documentnumber)) * -1)
),'#.###,##')
Hi,
I used if (s_artikel.company = number, num (..)) but this is what it looks like and I want everything to be visible