6 Replies Latest reply: Apr 11, 2017 3:04 PM by Sunny Talwar RSS

    Include null values in set analysis not working

    Eli Karp

      Hi All,

       

      I am using the following code. I realized some values do not have a year associated and I want to show these. My initial code was this:

       

      IF

       

      (ISNULL(GETFIELDSELECTIONS([Year])),

       

       

      Sum({<[Year]={'($(vCurrentYear))', '($(vPrevYear))','($(v2PrevYear))'}, [Ledger Code]={'1','23','63'}>} [PO Line Amount Billed Functional]),

       

       

      Sum({<[Year]={'=GETFIELDSELECTIONS([Year])'}, [Ledger Code]={'1','23','63'}>} [PO Line Amount Billed Functional]))

       

      I added the following in red()

       

      IF

       

      (ISNULL(GETFIELDSELECTIONS([Year])),

       

      Sum({<[Year]={'($(vCurrentYear))', '($(vPrevYear))','($(v2PrevYear))', "*"}, [Ledger Code]={'1','23','63'}>} [PO Line Amount Billed Functional]),

       

      Sum({<[Year]={'=GETFIELDSELECTIONS([Year])'}, [Ledger Code]={'1','23','63'}>} [PO Line Amount Billed Functional]))

       

      I'm not sure how else to go about this. Suggestions?

       

      Thanks