Ratio of sum (1 Viewer)

[Abdallah]

Good morning
I have a query collect some field from other tables depend on about 5 main fields all u want to calculate ratio in every
Record which come from value of one record divided by total of some records in the same field how to do that

 

[plog]

It's best to describe data issues with data. Please provide 2 sets of data:

A. STarting data from your table(s). Include table and field names and enough data to cover all cases.

B. Expected results of A. Show what data you expect your query to produce when you feed it the data from A.

Again, 2 sets of data--starting and expected.

 

[June7]

Might be easier to accomplish in a report that uses Sorting & Grouping with aggregate calcs.

 

[Abdallah]

Here is the case there is a query collect 4 table all i want add another expression in query to calculate ratio of every cost type
For example main_contract has "concret"
Related to sub_main_contract has"concret ladder" related to block has "fence" all has total of estimated price
Here is the point i want ratio of every cost type from total estimated price

 

[Minty]

Without seeing samples of your data e.g. What you have and what you are expecting to see, no one is going to be able to magic up an answer for you I'm afraid.

Either create some samples in Excel or Upload a stripped-down version of your tables with enough data to cover all the possible outcomes.

 

[Abdallah]

I tried to upload it but attach doesnot accept my file

 

[Abdallah]

 

[Minty]

Have you compacted and repaired it, then put it in a Zip file?
A picture isn't much help for us to work on.

 

[Abdallah]

Yes compacted to rar and zip nothing new

 

[Minty]

How big is the Zip file?
We only need a small set of initial data and your expected results.

 

[June7]

Trying to accomplish all in query will likely involve subquery or joining to another query that provides aggregate calcs. Still suggest this may be easier done in report design.