Skip to Content
0
Former Member
Apr 23, 2014 at 05:46 PM

Formula to Display Value Based on Another Field's Value

1199 Views

Hello,

I have a column that displays the vehicle used for drives, but the report also lists fixed sites that do not have a vehicle assigned.

What I'm trying to accomplish is to utilize a formula but I'm having trouble with getting it to work. What I've got is:

if {CenterDetail.CenterType}=0 then {MobileSetupMaster.ShortDesc}

else

...

I'm not sure what to place in the else statement to make the value equal to null.

Suggestions?