joostvb

basic if statement not working?

Discussion created by joostvb on Sep 25, 2013
Latest reply on Sep 25, 2013 by BruceHerbach

So i have a data set with projects that are either from framework programme 6 or 7. If it's in FP7, the field "fp7" == 1. if it's in FP6, the field "fp7" == 0.

 

for userfriendlyness i want to display the full titile of the framework programme in a layout.

I created a field "FWprogramme" that has a calculated value. The value is calculated as follows:

 

If ( FP7=1; "Framework Programme 7"; "Framework Programme 6" )

 

the "fp7" field is stored as a number.

 

In the layout displaying the "FWprogramme" field, nothing shows up, no error or any output.

 

Why ?

Outcomes