Data Integration from external excel table

[Finance19]

Dear all,

I got two field in my qvw: SalesObjective and SalesReal

The expression SalesReal/SalesObjective gives the % of realization (lets say 93%)

In a separate table (on excel) I got a coeficient linked to this % or realization (e.g. 0.9)

How can I integrate the data of the second table in my qvw so that when I  calculate SalesReal/SalesObjective in my expression it gives me the coeficient 0.9 ?

Thank you !

Baptiste

[its_anandrjs]

Hi,

You have to link this data with your fact table to get properly effective in a row.

Regards,

Anand

[jonathandienst]

You will need to round the ratio to link with another table. To get a value of 0.9:

Round(SalesReal/SalesObjective, 0.1)

 Or use Floor() or Ceil() as appropriate