Hi Team,
I want to calculate the % based on two different tables where I am using addcoltotals to calculate grand total.
table 1:
A B C
v1 v2 v3
v4 v5 v6
T1 T2 T3 --- > grand total
table 2:
A B C
x1 x2 x3
x4 x5 x6
T4 T5 T6 -> grand total
I want to calculate :
F1 =T1/T4
F2 = T2/T5
F3 = T3/T6
could you please help me to find the solution.
can I store values of T in token and use eval command to calculate the results.
looking forward for the help
