You’re offline. This is a read only version of the page.
315
Hi!
I have the following tables in Dataverse:
1. Oil types
2. Size of different canisters
Example for table 1:
Example for table 2:
It is built this way because there can be serveral different sizes of canisters and locations for each oil type at our facility.
Question:
Would something like this be possible to do?
Hi mrstian89,
As per my understanding 'Oil types' & 'Size of different canisters' is having a 'one to many relationship'. What you need is a combination of rollup columns and a calculated column.
In 'Table 1 or Oil types' you need two rollup columns. One for the 'number of records or number of canisters' and the other for aggregated 'Size'. Now you are able to calculate oil quantity by applying the formula in the third calculated column.
Let me know if I can provide more details for you.
Thanks
Regards,
Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
Share
Report
All responses (
Answers (
