Less than statement with a measure.

[Anonymous]

I'm trying to edit the following expression/measure to show only payment amounts less than -$20.00.

Column/Measure: Tx Payment Amt

Expression: Sum({< [Tx Payment Flag] = {1} >}[Tx Amt])

[YoussefBelloum]

Hi,

try this:

=Sum({< [Tx Payment Flag] = {1},[Tx Amt]={"=sum([Tx Amt])<-20"} >}[Tx Amt])

[sasiparupudi1]

May be use an if

Sum({< [Tx Payment Flag] = {1} >} If([Tx Amt]<-20,[Tx Amt],0))

[Anonymous]

Thank you that worked! Now, I would like to exclude any Tx Payment Amt = 0  along with the current parameter.  No matter what I try, I'm still showing 0.00 values in my output.

[Mark_Little]

Hi,

Just to confirm are Tx Payment Amt and [Tx Amt] different fields?

If so then

Sum({< [Tx Payment Flag] = {1}, [Tx Payment Amt]={'> 20'}>}[Tx Amt])

Mark

[Anonymous]

So, Tx Payment Amt is the field/measure I am pulling into my table.  Tx Amt is a separate dimension that exists in the expression for Tx Payment Amt.

The expression for this measure which is constructed by a development team is:

     Sum({< [Tx Payment Flag] = {1} >}[Tx Amt])

I would like to edit this expression so the Tx Payment Amt column pulls values less than -$20.00 and not equal to 0.00.  

The following expression pulls Tx Payment less than -20.00 but I'm still showing values equal to 0.00.

Sum({< [Tx Payment Flag] = {1} >} If([Tx Amt]<-20,[Tx Amt],0))