Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Here is my special formula 😉 but i don't know why it won't work.
I only want to see set analysis choice but it does not work, for example i say that i only want to see the customer 70407 but in the list are also other customers.
Does anybody know whats wrong? Is it completly wrong what i do?
sum(aggr(sum({<[RMA_ClaimType]={'accepted claim'},[Customer_Number]={70407},[ArtikelBezCarbon]={'L1'},[RMA_Typ]={'Reklamation'},[Lagerort_Lieferung]-={'RMA Abgangslagerplatz'}>}DISTINCT[RechPos_RMA_Menge]),RMA_Id))
Thank you very much!
{'70407'}
Hi!
Thank you but i dont think this is the solution, originally i had this syntax.
Greetings
sorry!, you have to reply the set analysis sintax for the AGGR aggregation too
Hi!
I have only this formula. 😉
I want the summary of RechPos_RMA_Menge (=amount)
where the values are
[RMA_ClaimType] = {'accepted claim'}
[CustomerNumber] = {'70407'}
[ItemName] = {'L1'}
etc.
based on RMA_Id (Claim Id)
Greeitngs
Roland
Without data for testing,, i should use something like this :
sum(
{< RMA_ClaimType = {'accepted claim'}, CustomerNumber = {'70407'}, [ItemName] = {'L1'} >}
aggr(
{< RMA_ClaimType = {'accepted claim'}, CustomerNumber = {'70407'}, [ItemName] = {'L1'} >}
sum(
{< RMA_ClaimType = {'accepted claim'}, CustomerNumber = {'70407'}, [ItemName] = {'L1'} >}
RechPos_RMA_Menge)
,RMA_Id))
Thank you very much!
I will try this and give you reply.
Greetings
Roland