AnsweredAssumed Answered

ExecuteSQL : Calculation based on 2 calculated members

Question asked by FredH on Dec 27, 2014
Latest reply on Dec 31, 2014 by philmodjunk

Title

ExecuteSQL : Calculation based on 2 calculated members

Post

Hi Experts,

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!
Kind regards,

_Fred_

Outcomes