Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a grid
A B
1 1/(1+2+3)
2 2/(1+2+3)
3 3/(1+2+3)
how can I get the desired results of column 'B' by using formulae, value of 'A' are coming from expressions so they keeps on changing.
Any thoughts?
Best Regards,
Gaurav Tyagi
Hey Anthony use this equation for B
B= sum(A)/sum(Total A)
Hope it helps.
Have a nice day
Gaurav
Nope I didnt used it in the script.
But I found a way to do it
Thanks for your help
Gaurav
Hi Gaurav,
Very helpful!
Thanks again for your help,
Anthony
Hi Gaurav,
Very helpful!
Thanks again for your help,
Anthony