7 Replies Latest reply: Jul 20, 2011 5:22 AM by Byron Van Wyk RSS

    Dimension Expression: If Clause

    Byron Van Wyk

      Hi Guys,

       

      I have a database that has a list of names and the hours that these people worked. I am busy creating an invoicing checking report and need some help figuring out how to do this one thing in particular.

       

      I want my dimension, which is "Name" to list only names and sum hours for where I have an if clause. The if clause would work like this. If the person has a particular cost code appearing more than once for a particular week, list his name and his hours for where there is a 'duplicate' essentially. How would I do this?

       

      Thanks, Byron