topic Re: Sum two fields from different excel sheets in SAS Visual Analytics

Sum two fields from different excel sheets

KiranPatil — Mon, 15 May 2017 06:00:31 GMT

HI All ,

Iam Newbiee in SASva so need help

I need to Sum 2 field from different excel sheets , iam not able to achive it . Should i do in a Text box or table ? Please help

Thnaks and Regards

KIran

Cheers

Re: Sum two fields from different excel sheets

TheShark — Wed, 17 May 2017 19:52:22 GMT

Hi Kiran,

Best practice is to have your data merged and ready to go before uploading to VA so you can work from a single data source but you should be able to do this with a data query. I searched the forum and found a good post for you to reference, I hope it helps!

https://communities.sas.com/t5/SAS-Visual-Analytics/Combining-report-data-sources/td-p/217673

Re: Sum two fields from different excel sheets

KiranPatil — Fri, 19 May 2017 06:28:28 GMT

Thank You 🙂