Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello at all,
i need help. I´m a newbie to Set Analysis. I want the sum from Customers which have bought
one or more Articels from a Group.
Here my example which doesn´t work:
sum({<Artikel.Family={1,2,3,4}>#Kunden)
#Kunden: is a flag with 1 inside to count it up
Artikel.Family: Inside these are some numbers from 1-etc. (Group)
What do i make wrong in the function?
Greets
=Sum({$<Artikel.Family={$(=GetFieldSelection("Artical"))}>}#Kundan)
in this (=GetFieldSelection("Artical") will be Your selected articals.
I don't think you need a flag. Can you tell me how your tables structure is? you can count directly the the cUstomer ID
Hello,
yes i can make it so
sum(#Kunden)
then i get the Customer, but i want to display some different values for Customer.
I want to show Customer who bought in Group 1,2,3,4 and in 10 and so one, so i had
to make a function or not? I would show it in a table diagramm.
Greets
=Sum({$<Artikel.Family={$(=GetFieldSelection("Artical"))}>}#Kundan)
in this (=GetFieldSelection("Artical") will be Your selected articals.
Thank you, thats right, and a last question. Where i have to use an "AND" operator when i want to show
the sum of Customer when they have bought for example in the group 1 and 10?
Greets to all of you
Just select only articles 1 and 10
Your right oh my god