1 2 3 4 5 Previous Next 61 Replies Latest reply on Feb 20, 2020 7:23 AM by Claudia Rosen Go to original post Branched to a new discussion.
      • 60. Re: Force Blanks to Show.
        Jesse Zhang

        Joe can you please explain a bit more on why window_max and attr of the dimension will keep all fields showing? i tried it and worked great, i even did across and down with 2 different fields, basically locked both columns and rows, but I am still fuzzy with the mechanics behind it. Thanks again for this wonderful solution.

        • 61. Re: Force Blanks to Show.
          Claudia Rosen

          Hi John,


          I have a similar issue, I have a data source that includes all students grade for a particular year, I passing with a filter a student that is not on that data source and getting "none" as a result, I would like to replace this with "n/a", tried different routes none are working. Any suggestions


          if [grade] = "" then "n/a" else [grade] end


          if isnull([grade]) then "n/a" else [grade] end


          ifnull ([grade], "n/a")

          1 2 3 4 5 Previous Next