What is the content of the field ACTIVE? ie what do you get when you use
{Mergefield Active} on its own? Use this result in your condition. If the
field is either empty or has content then

{IF{Mergefield Active} <> "" "Active" "Not Active"}