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.