Hey!
So truly, I have spent more than a day's worth of total hours on this. I finally figured it out literally 5 minutes ago. It turns out, for me I had to create two calculated items, then put those two items into an aggregated measure. Here's a bit more detail in case anyone else runs into this.
Originally, my data only had 'Amount' as a Measure. I then created calculated items for 'Actuals 2018 Revenue' and 'Budget 2018 Revenue' via simple If...Then statements because I had to qualify that within actuals and budget I only wanted account types like revenue. Lastly, I created an aggregated measure simply dividing the two calculated items. Voila!
I have no idea why it has to be like that, but apparently it does. Hopefully this helps for anyone else trying to do the same thing.
Hey!
So truly, I have spent more than a day's worth of total hours on this. I finally figured it out literally 5 minutes ago. It turns out, for me I had to create two calculated items, then put those two items into an aggregated measure. Here's a bit more detail in case anyone else runs into this.
Originally, my data only had 'Amount' as a Measure. I then created calculated items for 'Actuals 2018 Revenue' and 'Budget 2018 Revenue' via simple If...Then statements because I had to qualify that within actuals and budget I only wanted account types like revenue. Lastly, I created an aggregated measure simply dividing the two calculated items. Voila!
I have no idea why it has to be like that, but apparently it does. Hopefully this helps for anyone else trying to do the same thing.
Great to hear you solved the problem, @cnhodg! Thanks for posting your solution back to the community, which for sure will help out fellow members.
Best,
Anna
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.