Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community !!
I have a problem I think it's easy but I can not find the solution.
I'll want to create a KPI using a " Text Box " simple expression is:
= Sum ( { < Indicators = ' Economic Value Added ' } > } USD )
You see I have a dimension called "Indicators" but I just want the KPI to show that the result of the indicator ' Economic Value Added '
All good there, the difficulty I have is when I want to apply Set Analysis with variables as vSetQTD , vSetYTD etc .. ..
I don't know like writing the expression. Normally I would with
= Sum ( { < $ ( vSetYTD ) > } USD )
How do I get back my previous expression but only of my indicator " Economic Value Added '
Thank you very much , I think it is simple but I've been mulling over time .
Eduardo
May be like this?
=Sum({<Indicators = {'Economic Value Added'}, $(vSetYTD)>} USD)
what is the value of the variable $ ( vSetYTD ) ??
Hi,
Add this '{' in your expression.
I think it should be work.
= Sum ( { < Indicators = {' Economic Value Added ' } > } USD )
Hi Eduardo,
I suggest you to write it like a function:
Create a variable like this:
SUM({<$($1),Indicators = {'$2'}>},$3)
On text box:
= $(YourVarName(SetAnalysisYTDVarName,IndicatorFieldValue,FieldToSum)
With this you can write all your KPIs with only one variable.
Regards!
Expression could be depend on what value stored in variables $(vSetQTD) , $(vSetYTD).
Please let us know variables details.
- Regards,
Vishal Waghole
it Works!!!!! thank a lot Sunny
Ok!! You're Right! Thanks
Hi Saima!
It's =
PeriodID = {"<=$(=Max(PeriodID))"},
Year = {$(=Max(Year))},
Quarter = ,
Half = ,
Month = ,
Period =
Works pecfect with Sum({<Indicators = {'Economic Value Added'}, $(vSetYTD)>} USD)
Perfect!!! Manuel
It Works, much better into a new variable
Thanks