MoM growth of the current month in text object

[jmehul]

Hi All,

I want to make a text object (KPI) to show the latest month on month growth %.

I am using the Aggregate measure as follows:

( Period(_Sum_, 'sale'n, _ApplyAllFilters_, 'date'n, _ByYear_) - ParallelPeriod(_Sum_, 'sale'n, _ApplyAllFilters_, 'date'n, _ByYear_, _ByYear_, -1, _Full_, {Date}) )

/ ParallelPeriod(_Sum_, 'sale'n, _ApplyAllFilters_, 'date'n, _ByYear_, _ByYear_, -1, _Full_, {Date})

And then setting up the rank in the rank tab as month = max_month (top count =2)

I am able to see it in list table but when I put it on the text object, it is showing missing value which is obvious. 
As sum(missing , any value) = missing.

Is there any way in which I can do this thing.

 Thanks 

[MikeJenista]

What version of VA are you on?  The latest versions have a KPI object that does exactly what you want, but for earlier versions there are still some possibilities.

[jmehul]

I am using SAS VA 9.4

[MikeJenista · Accepted solution]

Okay, the simplest way I know to get the growth number to show is to assign the aggregated item to a chart where it would show as a single element.  For example, if you use the same rank you describe on a pie chart, you would get the aggregated value for only one slice (showing as the whole wheel).  You could then use the style and properties tabs to make the numeric value show very large and provide a title.

[jmehul]

Is there any other method or formula for calculating YoY, QoQ or MoM so that I can get rid of that missing value.

If not in SAS 9.4

Is there any other way on SAS VIYA