Please make an extract first and republish your twbx. You have live connected DS now.
Thanks for the response. I have figured it out. I just need to use the sum aggregate rather than the AVG function in my formula. I just did the sum(xxx)/sum(xxxx) and it is working!!