2 Replies Latest reply: Sep 6, 2017 11:33 AM by Ana Carina Rodrigues RSS

    How to count a field independently of the selection made?

    Ana Carina Rodrigues



      I have a column with years and another with quarters.


      I'm trying to get how much distinct values exists on the "CalendarJnJQuarterDesc" column for the selected year, but I don't want it to change the value according to the selected quarter.


      I'm using the following code:


      =count( DISTINCT {$<[Calendar JnJ Year]={$(=Max([Calendar JnJ Year]))}>}  [CalendarJnJQuarterDesc])


      each year has 4 quarters, so it should return always 4. But if I select Q1, it changes to 1.


      Can somebody help me?


      Thank you ^^