You’re offline. This is a read only version of the page.
Announcements
9
Hello everyone,
I have a table structure as shown in the diagram. Essentially, Table A contains one Table B, and Table B contains multiple instances of Table B-C, where each instance multiplies a quantity by the value of Table C.
I've successfully implemented a rollup on Table B, which is working fine. However, I now need these rolled-up values from Table B to be reflected in Table A, where I intend to further multiply them by another quantity.
Currently, I'm using a workflow to transfer values from Table B to Table A and table C to table BC. However, this approach falls short whenever modifications are made to Table B, BC, or C, as the trigger fails to capture the updated values.
Is it possible to perform this rollup directly within Table A? If so, how can I achieve this? I'm open to any additional suggestions or insights.
Thank you.
Hi @EToseto
You can do a direct rollup on table A if the lookup is also on table C, that is, A is the parent of C and this way you can go directly. Because of your relational model you are only using table B to accumulate and it wouldn't make as much sense. You can do it from A to C directly unless then B is separated into several registers and what accumulates in A is the sum of those in B, in this case you could do a little trick. Create a normal numeric field and fill it with JS so that it is equal to the rollup of table B and then use that value to create the Rollup of table A.
Important note remember that rollups do not refresh immediately, there is a method through JS to achieve this
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution
Follow me on Linkedin, I talk about Power Platform
www.linkedin.com/in/jonathan-manrique-rios
Share
Report
All responses (
Answers (
