Suppose there are 2 columns name and num
Ram 21
Mohan 32
Rohit 11
Arjun 51 . Sum is 115. so ratio per person becomes like 21/115 and so on for others. now suppose i have a new sum 700 and now i want to distribute in same ratio like for Ram it will be ((21/115)*700 ).
Can i get a query where we can do this calculation.
Thanks in advance.