Searching in a table

[#1]

Hi community,

Please i have a serious problem.

I have an EXCEL file. You can see it in attached file.

I have loaded this file in a qlikview table by this statement :

Tableau_De_Bord:
LOAD ID,
Label,
[Solde d'ouverture],
[Reelles YTD],
[Budget YTD],
[Prévisions YTD]
FROM
[STAR\EXCEL files\Tableau de bords.xls]
(biff, embedded labels, table is Feuille1$);

The field [Reelles YTD] contains the formula.

I want to obtain these formula using the value of ID field.

Please, it is very urgent.

Thanks.

[#2]

To use a formula from an external source use the $(formula_field)

Also noticed you need to remove the space after the =

= Sum

=Sum