Expression Help

[#1]

=If(GetSelectedCount(LuCurrencyType3) > 0 and [Year of Expense]=2016,

(sum([Expense]*Factors)/([Factors3])),

  (sum([ Expense]*(Factors))))

Is there anything wrong in the above expression ?

Thank you.

[sunny_talwar · Accepted solution]

May be reduce the excessive use of parenthesis to see if you have extra parenthesis in there:

=If(GetSelectedCount(LuCurrencyType3) > 0 and [Year of Expense]=2016,

(sum(Expense*Factors)/[Factors3]),(sum(Expense*Factors)))

[HirisH_V7]

Hi,

Check with this Expression,

If(GetSelectedCount(LuCurrencyType3) > 0 ,

(sum({<[Year of Expense]={'2016'}>}[Expense])*Sum({<[Year of Expense]={'2016'}>}Factors))/Sum({<[Year of Expense]={'2016'}>}[Factors3]),
  (sum({<[Year of Expense]={'2016'}>}[Expense])*Sum({<[Year of Expense]={'2016'}>}Factors))

Hope this Helps,

Hirish

[Anonymous]

may be this?

=If(GetSelectedCount(LuCurrencyType3) > 0 and [Year of Expense]=2016,

sum([Expense]*Factors)/[Factors3], sum([ Expense]*Factors))

What issue you are facing??

Are you getting any error as expression looks okay?

[#5]

Hi Pavana please try this expression.

if(GetSelectedCount(LuCurrencyType)>0 and [Year Of Expense]=2016,

(Sum({$<[Year Of Expense]={'2016'}>Expense})*Sum({$<[Year Of Expense]={'2016'}>Factors}))/Sum({$<[Year Of Expense]={'2016'}>Factors3}),

(Sum({$<[Year Of Expense]={'2016'}>Expense})*Sum({$<[Year Of Expense]={'2016'}>Factors}))

[Digvijay_Singh]

It appears you have kept Factors3 out of aggregation functions, which needs to be validated through sample data. Check if it should be inside sum or not.

[PrashantSangle]

Hi,

did you get any error??

Syntax wise, it is correct.

might be issue because of naked expression for Factors3..

Try below,

If(GetSelectedCount(LuCurrencyType3) > 0 and [Year of Expense]=2016,

(sum([Expense]*Factors)/sum([Factors3])),

  (sum([ Expense]*(Factors))))

Regards

[engishfaque]

Dear Pavana,

Here is an expression,

Expression 1:

----

=If(GetSelectedCount(LuCurrencyType3) > 0 and [Year of Expense] = 2016,

  ([Expense]*Factors)/[Factors3],

  [Expense]*Factors

  )

Expression 2:

----

=If(GetSelectedCount(Len(Trim(LuCurrencyType3))) > 0 and [Year of Expense] = 2016,

  ([Expense]*Factors)/[Factors3],

  [Expense]*Factors

  )

Kind regards,

Ishfaque Ahmed

[#9]

=If(GetSelectedCount(LuCurrencyType3) > 0 ,

  sum([Expense]*Factors)/[Factors3],

   sum([Expense]*Factors))

The above expression works fine and give me the amount for all the year,where as I want to filter for current year and when I add the Year filter still it shows the amount for all the years.

If(GetSelectedCount(LuCurrencyType3) > 0 and [Year of Expense]=2016 ,

  sum([Expense]*Factors)/[Factors3],

   sum([Expense]*Factors))

If I filter year from list box it will show amount for current year,but I want to do that in expression itself.

None of the above expression is working.Not sure why.Thank to you all though.