Hello everyone,
I have been trying to resolve this issue for over two weeks. Please, kindly help.
THE ISSUE
I have a column in the sales Report page of my application and each row in Sales Report page column is a product on sale and supposed to be an addition of all sales transactions that occurred for that particular product.
Example
Sales page
SN Product Quantity Amount
1. cabin 3 3000
2. biscuit 10 1000
3. cabin 2 2000
4. cabin 7 7000
Sales Report page
SN Product Quantity Sold
1. cabin 12
2. biscuit 10
THE PROBLLEM
The table below is example of what my application Sales Report page is currently displaying:
2. biscuit 12
The problem is that all product carries the quantity sold for the first product.
actual sales for cabin is 12
actual sales for biscuit is 10
But my application displays sales for biscuit as 12 and cabin as 12
Please, kindly help me resolve the issue.
The application is built on reactive.
Hi @Harrison Can you please provide OML.
Asad
Hi Asad,
The OML file is larger than the maximum allowed here. It is bigger than 4mb. Except I have an email i can send it through.
Hello Harrison,
In your table's column , the value of expression in column should be "Source.List.Current.Attribute"
Please check the screenshot below, I have attached the source of table and its column value,
Hope this help, let me know if you have still an issue,
Regards,
Komal
Hi Komal,
It did not work as expected. Kindly assist further. Thanks
Hello,
Is is possible for you to share the screen shot of code ?
I think if you have aggregate used to retrieve data of sales report page you can group by product Name or product Id and using count of quantity column it should work
Hi Mostafa,
Thanks for your response.
It counted the number of times sales transaction occured for individual products instead of the quantity sold.
1. cabin 3
2. biscuit 1
Please kindly assist further
I am sorry its my bad. You need to use sum instead of count for quantity.