Hello!
I have the following two tables in my application:
Table 1:
| Quantities (#) | Total Sent | Anomaly | No Anomaly | Completed | Pending |
|---|
| Zone A | 100 | 30 | 60 | 90 =30+60 | 10 =100-90 |
| Zone B | 50 | 10 | 25 | 35 =10+25 | 15 =50-35 |
Table 2:
| Quantities (%) | Total Sent | Anomaly | No Anomaly | Completed | Pending |
|---|
| Zone A | 100 | 33% =30/90*100 | 67% =60/90*100 | 90% =90/100*100 | 10% =100%-90% |
| Zone B | 50 | 29% =10/35*100 | 71% =25/35*100 | 70% =35/50*100 | 30% =100%-70% |
Is there any way to use in table 2 results from expressions calculated in table 1?
In order to not calculate the same thing both times... Or it is not possible to do that?
Maybe if I create a single table with all the data, it would be easier?
What do you recommend?
Thank you!!!
