6 Replies Latest reply on Sep 11, 2017 11:23 PM by Gabriel Belba

    How to use correct division with SQL server connection

    Gabriel Belba

      Can someone to help me with a simple calculation?

       

      I have next computation : [EARNED HOURS FCST]/[EARNED HOURS PY] but the value is wrong displayed.

      values are: 1430520/1436635 and the result is 80,31 which is wrong, need to be 0,99574

       

      I try also SUM([EARNED HOURS FCST])/SUM([EARNED HOURS PY]) but the value is already aggregated and I get an error.

      As a data source I use a connection to SQL server.

       

      Thanks in advanced.