Formula problem

[rolandg1881]

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!

[QFabian]

{'70407'}

[rolandg1881]

Hi!

Thank you but i dont think this is the solution, originally i had this syntax.

Greetings

[QFabian]

sorry!, you have to reply the set analysis sintax for the AGGR aggregation too

[rolandg1881]

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

[QFabian]

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))

[rolandg1881]

Thank you very  much!

I will try this and give you reply.

Greetings

Roland