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 ?