FM - Intermediate/Advanced Portal Filter Issue

I have successfully been able to create portal filters for County, Town, (and with EE help) even a multi-selection Building Type field.  However, now I am trying to add Unit Sq Ft and Rent/Month.  However, it did not work.  Where did I go wrong?

See screen prints attached.  The two new fields are related are as follows:
1. cfilterBldgType_Select (see screen print)
2. The c_FilterUnitSF (this calc field contains):
Case (
SQ_FT  = 700; "0-700" ;
SQ_FT   = 701 and SQ_FT  = 1000; "701-1000" ;
SQ_FT   = 1001 and SQ_FT  = 1200; "1001-1200" ;
SQ_FT   = 1201 and SQ_FT  = 1500; "1201-1500" ;
SQ_FT   = 1501 and SQ_FT  = 2000; "1501-2000" ;
SQ_FT   = 2001 and SQ_FT  = 4000; "2001-4000" ;
SQ_FT   = 4001 and SQ_FT  = 9000; "4001-9000" ;
SQ_FT   = 9001; "9001 & over" ;
ValueListItems ( Get ( FileName );"RentalSqFt" )
)

My value list is
"RentalSqFt"
0-700
701-1000
1001-1200
1201-1500
1501-2000
2001-4000
4001-9000
9001 & over
-UnitSFFilterIssue.JPG
-UnitSFfilterIssue2.JPG
-UnitSFfilterIssue3.JPG
LVL 2
rvfowler2Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Will LovingConnect With a Mentor PresidentCommented:
The first thing I would check is that your selection field and your calculation field result are both text and not numbers. It also looks to me like your calculation for c_FilterUnit SF_Select is referencing the wrong global field. It references g_FilterBldgType instead of g_FilterUnitSF.
0
 
rvfowler2Author Commented:
Crud, it was the reference to the wrong global field.  I changed that somewhere and most not have saved it one time.

Also, good catch on the number vs. text, but I had already thought of that.  Normally, a calc for SF would result in a number, but when you are representing it with a range, it is text.

Thanks.
0
All Courses

From novice to tech pro — start learning today.