Share
ReportHi, I am fairly new to powerapps and I am producing a CRM for a business that is rather bespoke.
I have all elements together now using model driven apps and the accounts, contacts, jobs, tasks etc all work well.
We have moved to quoting and I am having a few issues.
I have the quote entry done, the items added to the quote from 2 tables called materials and services.
Each table has columns that use calculations to work out amounts and costs based on information entered such as quantity, vat and markup values.
I then want to add together the individual row totals of before vat, after vat etc. I thought great, I would use a rollup column in the parent table to give me these values to find that you cant use rollups on calculated columns!
This has left me with just this last little bit to resolve before the system is fully usable to provide the quotes.
I need to be able to generate these values to add to the quote and the generated word document.
I have tried using a embedded canvas app and the modeldrvienformintegration option but when I then try to sum the lookup columns the calculations tell me that the values are blank!
I have the formula below. I have been on this for the last few days and my head is just getting foggy now and I cant see how to resolve this or find a solution or if I am missing something simple. The rollup function was perfect for what I needed until I came across the fact you cant use on calculated fields.
The sum I am using is here, where SolarisQuotes is the parent table, 'Solaris Quote Number' = the quote number primary field, materials lookup = the lookup field in the solarisquotes table, 'Total Inc Markup' = the column of which I want the related fields to add up.
Sum(LookUp(SolarisQuotes, 'Solaris Quote Number' = [@ModelDrivenFormIntegration].Item.'Solaris Quote Number').'Materials Lookup'.'Total Inc Markup')
I would be really grateful for any help you can provide.
All responses (
Answers (
329
