info requested expression

[#1]

All, I am stuck with below expression

instead of Field name in sum function I need to resolve field as below, can someone provide solution to it.

Sum( {$ <[A Date]={">=MonthStart(Max([A Date]) <='29/11/2016' "} >}  $($(='eAmt' )) expression)

example -Sum( {$ <[A Date]={">=MonthStart(Max([A Date]) <='29/11/2016' "} >}  $($(='eAmt' )) $($(='eAmount' & %Country)))

[Anil_Babu_Samineni]

You may post full expression. I mean to say with Variable / What were these? eAmt & eAmount & %Country

[#3]

please help finding issue here....

where VABDate is variable with format  02/12/2016

Sum( {$ <[A Date]={">=$(=date (MonthStart(Max(A Date]) ),'dd/mm/yyyy'))<= date('$(vABDate)','DD/MM/YYYY') "} >} XXX )

[Anil_Babu_Samineni]

Try with this

Sum( {$ <[A Date]={">=$(=date (MonthStart(Max(A Date]) ),'dd/mm/yyyy'))<= MakeDate('02/12/2016') "} >} XXX )

[hemanthaanichet]

Hi Rajesh

U may try the below expression:

Sum( {$ <[A Date]={">=$(=Date (MonthStart(Max(A Date]) ),'DD/MM/YYYY')) <= Date('Today()',DD/MM/YYYY) "} >} XXX )

Regards

Hemanth

[#6]

All,

I need some help on resolving an expression ...

This is working fine...Sum( {$ < [A Date]={">=$(vMonthStart) <=$[A Date]"} >} [#AMT]  )

However want to redefine and make it parameterised

step1:-

defined function

eAmt=Sum({$<$(vCommonFilter),)>}[#AMT])

step 2:-

trying to resolve

($($(=eAmt), $(=[A Date]={">=$(vMonthStart) <=$[A Date]"}) )

basically I am trying to pass date condition( [A Date]={">=$(vMonthStart) <=$[A Date]"}) to the sum function at run time. I am getting null value as output

Thanks in advance!