2 Replies Latest reply: Jan 24, 2017 6:22 AM by Marcus Sommer RSS

    Max(Date) in a table

    Florian Lemarquand

      Hello,

       

      In a table, I try to count point  if point =1  and I divide it with the sum of point,  so I use this :

      Count({$ <Points={'1'} >} Points)/Count(TOTAL_LINE)

       

      And it works but now I want to have it only for the last month. I used a set analysis :

      Count({$ <Points={'1'},[Month] = {'$(=Max([Month]))'}>} Points) / Count({<[Month] = {'$(=Max([Month]))'}>}TOTAL_LINE)

      But it returns me only zéro value so i tried with with an "if" but it give me the same result.

       

      Have you got an idea?