Explanation Required

[#1]

Can anyone please explain the expression given below?

Sum( {< _Source = {"Application Approval Rate"}, Year = {'$(=Year(Max( { < Actuals = {">0"}  >} MonthYear)))'}>} Actuals)

[its_anandrjs]

From above expression

Where your Actuals is >0 then you get Max valye of MonthYear and get Year from the MonthYear field and compare it to the Year field and also checks _Source = Application Approval Rate then Sum the Actuals.

Your Expression has parts like

1. For Sum Actuals Sum( Actuals)

2. Where  _Source = {"Application Approval Rate"}  Means _Source = Application Approal Rate.

3.Where your Year = Max(Year)  which is calculated by  Year = {'$(=Year(Max( { < Actuals = {">0"}  >} MonthYear)))

4. If all condition satisfied then calculate the Sum(Actuals) by the expression

Sum( {< _Source = {"Application Approval Rate"}, Year = {'$(=Year(Max( { < Actuals = {">0"}  >} MonthYear)))'}>} Actuals)

[MK_QSL]

Sum( {< _Source = {"Application Approval Rate"}, Year = {'$(=Year(Max( { < Actuals = {">0"}  >} MonthYear)))'}>} Actuals)

SUM(Actuals)           Will give you sum of Actuals

Where

1)     _Source = Application Approval Rate

2)     Year = Max Year (i.e. Year = Max(MonthYear)

          Where  a)     Actuals > 0

Hope this helps...

[qvwarning]

Hi,

the expression sums the dimension Actuals

based on the current selection

where the _Source  field has a value Application Approval Rate

and the Year are the last possible (Max) of 'MonthYear' for Actuals greater then 0.

br

Andreas

[#5 · Accepted solution]

Sum of Actuals

         Where:

                  _Source = "Application Approval Rate"

                  AND

                  Year = 

                           {

                                    Max of MonthYear

                                    Where :    

                                             Actuals > 0

                           }

[#6]

Thank you all for your help

[MK_QSL]

Please close the thread by selecting appropriate answer so that others can also take benefit.

[MK_QSL]

I also gave the same answer

[its_anandrjs]

Did you check my answer also that is also same.

[preminqlik]

you kow manish , i think gaurav sharma is from india ....... here also ladies reservation works....:)