View Single Post
  #2 (permalink)  
Old May 31st, 2011, 01:18 PM
aztech2403 aztech2403 is offline
Registered User
Points: 17, Level: 1
Points: 17, Level: 1 Points: 17, Level: 1 Points: 17, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default I found my own solution

After playing around with different expressions, I finally came up with one that worked.

The REVVAL fields are part of a "SWITCH" expression called "RebateAmt", where if the property name is this, then use this REVVAL field.

With that in mind, I created this expression and it works perfectly!

=Iif(isnothing(Fields!RebateAmt.Value)or
(Fields!RebateAmt.Value)=0,true,false)