ExecuteSQL : Calculation based on 2 calculated members
I would like to create a line graph that shows a ratio using ExecuteSQL.
The formula should look like this :
ExecuteSQL("SELECT (sum(E.\"NOP Frais incl.\") / sum(E.\"Nombre\") AS Result FROM Exploitation AS E GROUP BY E.\"Année\" ";"";"")
It seems that ExecuteSQL has some issues with calculations based on calculated members because the query (via graph as also via the data viewer) gives "?" as a result. Do you know what type of trick I could use to make this ExecuteSQL work?
Thanks in advance for your input!