Hey Madelyn,   We are trying to get SAS to help us with this but I discovered that if I change all of the colors in our report to a different arbitrary color (I chose black)  and then reassign our college's palette of colors the graphs seem to display correctly although I have seen a random odd color appear.   Thanks,   Gary ... View more

Will do, probably not today though.   The colors I am trying to use though are the ones in the custom theme and I built this report from scratch with a template that uses that theme.   Thanks! ... View more

Yes we are. ... View more

Thanks, Madelyn!   We are using Chrome and I.E. as well as iPad. All three display the same colors which are not the selected colors in the report. Clearing the cache did not solve the issue. Here is a link to the report (it is publicly consumable);   Enrollment - the Enrollment Explorations tab   What colors do you see?   Gary ... View more

Hey Robert_T (or anyone),   This "seems" WAY more complicated than it should be. In the attached image I describe what I am trying to do. I have a category titled "Days From the 1st Day of Classes" that are my row values. I have two semesters (Term_Year) that is a measure as columns. They are '2017' and '2018'. I "simply" need to calculate the percent difference for each row.                              2017                 2018 Days From       Headcount       Headcount 42                       15,576               15,587       Need percent change here                                                                           as the third column   The user doesn't want dates they need the number of days pre and post the first day of classes and the percent (and actual number) difference for each day. I cannot do this in EG since this data will be linked to a drop-down list for several different categories of students. The last day this runs there will be about 100 rows and the data will have interactions with a line graph and possibly a pie chart.   Days From the First Day of Classes   - Category, Format Float Headcount   - Aggregated Measure - Distinct [_ByGroup_] ('Student_ID'n) Term_Year   - Category - Format $   Thanks!   Gary     ... View more

Thank you Robert_L,   Can you give me a bit of clarity on the 'Year'n value? I substituted the variables I use ('Term Year'n) and get the error(s) below. This is a character field.   ( ParallelPeriod(_DistinctCount_, 'Student_ID'n, _ApplyAllFilters_, 'Term Year'n , _Inferred_, _Inferred_, 0, _Full_, {Date}) - ParallelPeriod(_DistinctCount_, 'Student_ID'n, _ApplyAllFilters_, 'Term Year'n, _Inferred_, _Inferred_, -1, _Full_, {Date}) ) /  Abs(ParallelPeriod(_DistinctCount_, 'Student_ID'n, _ApplyAllFilters_, 'Term Year'n, _Inferred_, _Inferred_, -1, _Full_, {Date}))   Invalid data item for this context: Term Year Invalid data item for this context: Term Year Invalid data item for this context: Term Year   Thank you,   Gary     ... View more

Hey ML,   No responses/solutions yet. Several views but it seems this isn't possible in VA.   Gary ... View more

Hey FredrikE,   Yes, my table name is the same, the field names are the same, the lengths are the same, and the case is the same.   Madelyn_SAS sent me some code to run on the server in debug mode to show the actual value of SUB::SAS.USERID value but our IT group does not see the results she referred to.  They are still trying to produce the results she explained.   SAS does some great things but it is these small "basic/fundamental" things that escape me as to why? Exporting a chart to Excel without having to use Flash, see the value of a user id variable, drop results or a value into a text box in a report.     Thanks! ... View more

Thank you as always Madelyn_SAS! I have checked all of the possibilities I can and all turn up the same; eight characters in length as well as defined that way. It seems I cannot "see" the value for SUB::SAS.UserID or SUB::SAS.ExternalID to validate what the report is capturing, If anything.   It seems that I should be able to dump the value into a text box or something but SAS does not have that functionality. We are upgrading to SAS VA 7.4 next week. I hope this will solve this problem.   I have attached a document that better explains what I am doing.   Thanks,   Gary ... View more