4 Replies Latest reply: Oct 31, 2017 10:18 AM by William Fu

Filtering a certain Day number in Set analysis

William Fu Oct 31, 2017 9:51 AM

Any ideas why the following expression doesn't work?

Sum({$<LLR.PdCorrente-={'100'}, Day(DtRef)={1}>} Saldo)

I want the measure to only sum the values for the first day of each month.

Re: Filtering a certain Day number in Set analysis

Sunny Talwar Oct 31, 2017 9:52 AM (in response to William Fu)

Create a new field in the script and use the field name in set analysis
Day(DtRef) as DayRef

and then this
Sum({$<LLR.PdCorrente-={'100'}, DayRef={1}>} Saldo)
Like Show 0 Likes (0)

Actions
- Re: Filtering a certain Day number in Set analysis
  
  William Fu Oct 31, 2017 9:57 AM (in response to Sunny Talwar )
  
  Thanks for the quick response.
  
  Anyway to achieve this without messing with the script?
  I'm currently working with just the auto-generated script, and I'm not quite comfortable to press the "Unlock" button yet.
  Also, why doesn't the auto calendar create a day field?
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: Filtering a certain Day number in Set analysis
    
    Sunny Talwar Oct 31, 2017 10:06 AM (in response to William Fu)
    
    Try this
    
    Sum({$<LLR.PdCorrente-={'100'}, DtRef = {"=Day(DtRef) =1"}>} Saldo)
    
    Like Show 2 Likes (2)
    
    Actions
    - Re: Filtering a certain Day number in Set analysis
      
      William Fu Oct 31, 2017 10:18 AM (in response to Sunny Talwar )
      
      Perfect, thank you!
      
      Like Show 1 Like (1)
      
      Actions