Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Hi,
try this:
=Sum({< [Tx Payment Flag] = {1},[Tx Amt]={"=sum([Tx Amt])<-20"} >}[Tx Amt])
May be use an if
Sum({< [Tx Payment Flag] = {1} >} If([Tx Amt]<-20,[Tx Amt],0))
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.
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
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))