AnsweredAssumed Answered

Calculated value not showing for 'certain' field ValueList selections

Question asked by hzhawkins on Sep 18, 2013
Latest reply on Sep 18, 2013 by philmodjunk

Summary

Calculated value not showing for 'certain' field ValueList selections

Product

FileMaker Pro

Version

12

Operating system version

Mac

Description of the issue

I'm trying to produce a result from a calculation using If nested if statements. The first 27 nested statements work fine but the 6 after do not produce a result even though all data is the same as the 27 before.

Steps to reproduce the problem

I select one field drop down value "Location" and another field drop down value "Sitting"  and usually i get a result weather for the pricing of that location....

Expected result

I expect to get the same result as selecting any of the other drop down values.

Actual result

I do not get anything from 6 nested if statements (out of 27)

Configuration information

Here are my nested if statements. The last 6 do not produce any result.

If(Location = "River Balcony"; If (Sitting = "Sud-Fl" ; 1500 ;"" )) &
If(Location = "River Balcony"; If (Sitting = "Fd-Sd" ; 2500 ;"" )) &
If(Location = "River Balcony"; If (Sitting = "Sul" ; 3500 ; "")) &
If(Location = "Harbour Balcony"; If (Sitting = "Sud-Fl" ; 2000 ; "")) &
If(Location = "Harbour Balcony"; If (Sitting = "Fd-Sd" ; 3500 ; "")) &
If(Location = "Harbour Balcony"; If (Sitting = "Sul" ; 0; "")) &
If(Location = "Viceroy 1"; If (Sitting = "Sud-Fl" ; 4000 ;"" )) &
If(Location = "Viceroy 1"; If (Sitting = "Fd-Sd" ; 9000;"" )) &
If(Location = "Viceroy 1"; If (Sitting = "Sul" ; 0;"" )) &
If(Location = "Viceroy 2"; If (Sitting = "Sud-Fl" ; 4500 ; "")) &
If(Location = "Viceroy 2"; If (Sitting = "Fd-Sd" ; 5000; "")) &
If(Location = "Viceroy 2"; If (Sitting = "Sul" ; 0 ;"" )) &
If(Location = "Viceroy 3"; If (Sitting = "Sud-Fl" ; 5000 ;"" )) &
If(Location = "Viceroy 3"; If (Sitting = "Fd-Sd" ; 10000;"" )) &
If(Location = "Viceroy 3"; If (Sitting = "Sul" ; 0 ;"" )) &
If(Location = "Good Room"; If (Sitting = "Sud-Fl" ; 800 ;"" )) &
If(Location = "Good Room"; If (Sitting = "Fd-Sd" ; 1000;"" )) &
If(Location = "Good Room"; If (Sitting = "Sul" ; 1200 ;"" )) &
If(Location = "Pavilion 1"; If (Sitting = "Sud-Fl" ; 600 ;"")) &
If(Location = "Pavilion 1"; If (Sitting = "Fd-Sd" ; 800;"" )) &
If(Location = "Pavilion 1"; If (Sitting = "Sul" ; 1000 ; "")) &
If(Location = "Pavilion 2"; If (Sitting = "Sud-Fl" ; 600 ;"" )) &
If(Location = "Pavilion 2"; If (Sitting = "Fd-Sd" ; 800;"" )) &
If(Location = "Pavilion 2"; If (Sitting = "Sul" ; 1000 ; "")) &
If(Location = "Club House"; If (Sitting = "Sud-Fl" ; 900 ; "")) &
If(Location = "Club House"; If (Sitting = "Fd-Sd" ; 1600; "")) &
If(Location = "Club House"; If (Sitting = "Sul" ; 2000 ;"" ))&
If(Location = "Terrace"; If (Sitting = "Sud-Fl" ; 900 ; "")) &
If(Location = "Terrace"; If (Sitting = "Fd-Sd" ; 1600; "")) &
If(Location = "Terrace"; If (Sitting = "Sul" ; 2000 ;"" ))
If(Location = "Pav 1 & 2 & Club Exclusive"; If (Sitting = "Sud-Fl" ; 900 ; "")) &
If(Location = "Pav 1 & 2 & Club Exclusive "; If (Sitting = "Fd-Sd" ; 1600; "")) &
If(Location = "Pav 1 & 2 & Club Exclusive "; If (Sitting = "Sul" ; 2000 ;"" ))

Outcomes