0 Replies Latest reply: Oct 30, 2015 2:54 AM by Dennis Gadeberg RSS

    Dashboard metric - Error in expression: ')' expected. Urgent

      Hi,

       

      I'm having some trouble with a dashboard metric, with this error below.

      30-10-2015 07-47-14.png

       

      My expression is:

      IF([Dashboard Metric]='No. of projects',if([Product approved date] <> '',Count([Product approved date]), null()),

      If([Dashboard Metric]='Avg. development time',if([Product approved date] <> '' or [Sample received (ONLY DATES)] <> '', avg([Product approved date]-[Sample received (ONLY DATES)]), null()),

      null()

      ))

       

      I have also a calculated dimension which are:

      =if([Dashboard Metric]='No. of projects', [Dashboard Metric],

        if([Dashboard Metric]='Avg. development time', [Dashboard Metric],

        null()))

       

      I can't find what the problem is, and it is pretty urgent, since I have to hand this job in today.

      Can you please help me?

       

      Thank you so much in advance.

       

      Best,

      Dennis