Expression help please

[#1]

I have below expression in staright table and Total count and expression total are giving different counts.Can anyone help me make it right ?

IF(SUM([Expense Amount (USD)]) > '75000',

IF([Year of Expense] =YEAR(TODAY()),COUNT(%LeaseKey)))

[sunny_talwar]

Yes they will give different results based on the option you choose. Which one do you want to use?

[Simon_J]

Hi Pavana

Is this due to the dimension you have in the table. Are there any null rows suppressed in the table?

Thanks

Simon

[#4]

I need both the filters in the expression.Basically I have to show the Count of LeaseKey's where  current year sum(Expense)  greater than 75k.

[Anonymous]

Hi

try this  as an  expression in a PIVOT TABLE ?

COUNT(      {  <[ Year of Expense] =  {"$(=Year(Today()))"},  [Expense Amount (USD)]={">=75000"}  >  } %LeaseKey)

or

COUNT( Distinct    {  <[ Year of Expense] =  {"$(=Year(Today()))"},  [Expense Amount (USD)]={">=75000"}  >  } %LeaseKey)

[#6]

I need the sum of Expense amount...will this work as each lease has multiple rows of expense ? Thank you.