Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You have to link this data with your fact table to get properly effective in a row.
Regards,
Anand
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