6 Replies Latest reply on Dec 10, 2012 9:55 PM by todays_special

    AGO function issue

    todays_special
      Hello

      Im trying to use the AGO function in in my Column Formula to compare the difference between month to month. The formula is as follows:
      AGO("Fact - Revenue"."Revenue - DW","Period"."Period",1)

      ... but every time im getting the error message:
      Formula syntax is invalid.
      [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27037] Unresolved level: "Period"."Period". (HY000)
      SQL Issued: SELECT AGO("Fact - Revenue"."Revenue - DW","Period"."Period",1) FROM "LC ELT - Revenue and Margin"

      Not sure why this is. I have tried not inserting the 'time level' option which doesn't give me an error but does give me slightly incorrect results, just off the correct value.

      Has anyone experienced this before? If so, could you please let me know what you did to resolve it?