Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two buttons:
btnA - set expression to period jan-2016 to mar-2016
btnB - set expression to period apr-2015 to jun-2015
Then I have a variable vExpr:
- When btnA, vExpr gets the value 'MonthYear ={">=$(=Date(AddMonths(Min(MonthYear),-$(vMonthDiff)), 'MMM-YYYY'))<=$(=Date(AddMonths(Max(MonthYear),-$(vMonthDiff)), 'MMM-YYYY'))"}'
- When btnB, vExpr gets the value 'MonthYear ={">=$(=Date(min(addmonths(MonthYear,-12)),'MMM-YYYY'))<=$(=Date(max(addmonths(MonthYear,-12)),'MMM-YYYY'))"}'
Then I have an expression, in a text object with the following:
='=Money(SUM ({<' & $(vExpr) & ', AC_METRICA = {"Vendas Sem Iva"}>}[AC_VALOR_REAL]),vFormatNumber)'
I'm getting the next result in the text object:
=Money(SUM ({<MonthYear ={">=jan-2016<=mar-2016"}, AC_METRICA = {"Vendas Sem Iva"}>}[AC_VALOR_REAL]),vFormatNumber)
When what I really want is the value of the expression above, that should be "90 013 728 €", just for an example.
I think my problem is in the equal signs but I'm not getting there.
Can you please help ?
Thanks in advance,
Sílvia
May be add a dollar sign expansion
$(='=Money(SUM ({<' & $(vExpr) & ', AC_METRICA = {"Vendas Sem Iva"}>}[AC_VALOR_REAL]),vFormatNumber)')
May be add a dollar sign expansion
$(='=Money(SUM ({<' & $(vExpr) & ', AC_METRICA = {"Vendas Sem Iva"}>}[AC_VALOR_REAL]),vFormatNumber)')
Hi Silvia,
I always hit these sorts of problems and it always takes some fiddling to sort out
Does
='Money(SUM ({<' & $(vExpr) & ', AC_METRICA = {"Vendas Sem Iva"}>}[AC_VALOR_REAL]),vFormatNumber)'
Not work for you? If not then try
$(='Money(SUM ({<' & $(vExpr) & ', AC_METRICA = {"Vendas Sem Iva"}>}[AC_VALOR_REAL]),vFormatNumber)')
Hi Sunny,
Thanks for your help, it worked
I used this:
= $(='=Money(SUM ({<' & $(vExpr) & ', AC_METRICA = {"Vendas Sem Iva"}>}[AC_VALOR_REAL]),vFormatNumber)')
Hi Adam,
Your answer works as well, as long as I put another "=", like in the reply I gave to Sunny.
Thanks too