Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone please explain the expression given below?
Sum( {< _Source = {"Application Approval Rate"}, Year = {'$(=Year(Max( { < Actuals = {">0"} >} MonthYear)))'}>} Actuals)
Sum of Actuals
Where:
_Source = "Application Approval Rate"
AND
Year =
{
Max of MonthYear
Where :
Actuals > 0
}
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)
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...
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
Sum of Actuals
Where:
_Source = "Application Approval Rate"
AND
Year =
{
Max of MonthYear
Where :
Actuals > 0
}
Thank you all for your help
Please close the thread by selecting appropriate answer so that others can also take benefit.
I also gave the same answer
Did you check my answer also that is also same.
you kow manish , i think gaurav sharma is from india ....... here also ladies reservation works....:)