Expression help

[apthansh]

I have the below expression.

count( {<  Key = {"=sum([Amount (USD)]) >90000"} >} ID)

Here Amount USD is combination of Expense & Revenue So I want to Only include Expense which is greater than >90000.

Can I add that If statement within the above expression ?

I have a column called Type which  has Expense and Revenue.

sum(if(Type='Expense',Amount (USD)))

Thanks Much

[trdandamudi]

May be as below:

count( {<  Type={'Expense'},Key = {"=sum([Amount (USD)]) >90000"} >} ID)

[vishsaggi]

Did you try this ?

count( {<  Key = {"=sum({< Type = {'Expense'}>}[Amount (USD)]) >90000"} >} ID)

[sunny_talwar]

I agree with Vish. His expression should work for you.