Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys. I came upon this problem and do not know how to solve this. Basically I have the following data:
Item | Amount | Volumes |
F1111 | 300 | |
F2222 | 200 | |
S3333 | 10,000.00 | 500 |
F5555 | 100 | |
F6666 | 400 | |
S4444 | 10,000.00 | 500 |
20,000.00 | 2,000.00 |
This is a basic setup of an invoice. We sell 2 finished products (starting with F) as one set (starting with S). The system we are using allocates a sales amount to the SET which is correct. Thus we can sum(amount) an we will get total sales. The problem comes in with Volumes. If I sum(Volumes) I get double the number of volumes sold. How can I filter this so that it only shows the volumes of the SETS.
Thanks in advance.
Hello Christo
I'd use set analysis for that, something like
Sum({< Item = {"=Left(Item, 1) = 'S'"} >} Volumes)
Hope that helps
So you want the total for F and the total for S. You are asking to sum volumes for only specific items?
Or am i getting this wrong?
Yes, that is exactly what I want to do. If I sum only F I loose the amount part of S and the otherway around.
Hello Christo
I'd use set analysis for that, something like
Sum({< Item = {"=Left(Item, 1) = 'S'"} >} Volumes)
Hope that helps
Great. It works.
Thank you for the help.