how to add compute field into a table

[#1]

Hello,

i would add a compute field [EXIGENCE MERE] into a table but my result is empty

thanks for your help

LOAD

cat,

complexe

,

`id_project`

,

`id_req`

,

`id_req_parent`

,

origine

,

priority

,

reference

,

`req_description`

,

`req_name`

AS [exigence],

if

(fieldvalue('id_req_parent',NoOfRows('id_req_parent'))=0,[req_name] ,peek([req_name],fieldvalue('id_req_parent',NoOfRows('id_req_parent'))) ) AS [EXIGENCE MERE],

`req_type`

,

state

,

verif

,

version;

SQL

SELECT cat,

complexe,

`id_project`,

`id_req`,

`id_req_parent`,

origine,

priority,

reference,

`req_description`,

`req_name`,

`req_type`,

state,

verif,

version

FROM

`salome_pp_bdd`.REQUIREMENTS;

[#2]

You should just be able to add that field into your table expression.

First, you probably need to verify that the formula is working and you are getting data. You should create a Listbox for that field. If your formula is working, you should see data in that Listbox. If it is blank, you need to go back to your formula and figure out what is wrong.