Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Sum two fields from different excel sheets

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Sum two fields from different excel sheets

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


Accepted Solutions
Solution
‎05-19-2017 02:27 AM
Contributor
Posts: 33

Re: Sum two fields from different excel sheets

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

 

View solution in original post


All Replies
Solution
‎05-19-2017 02:27 AM
Contributor
Posts: 33

Re: Sum two fields from different excel sheets

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

 

New Contributor
Posts: 2

Re: Sum two fields from different excel sheets

Thank You Smiley Happy

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 238 views
  • 1 like
  • 2 in conversation