1 Reply Latest reply on May 9, 2018 1:25 AM by Ciaran Bource

    i need a filter in field when one value is 0 or NULL

    Ramiro Sanchez Fay

      Hi, i have a issue. I´m working in crime statistics. I have a region field (provincia), crime field (delito), "period" parameter. I need show the crime trend only when in this month do not have one value in zero or null, because i need total crime per month per all regions. And then, when a client select one region, i need to show the crime trend for this region.

       

       

      I did one step in "now" sheet, when i select all regions, i only show the crime trend when all regions do not have one value in zero.

       

       

      thanks in advance,

       

       

      Ramiro

      Version 10.5