3 Replies Latest reply on Aug 29, 2018 3:06 PM by Deepak Rai

    Nested IF in Fixed LOD?

    jon rios

      i am not sure is this is correct, can someone confirm this is acceptable to nest an IF with an IF in Fixed expression


      { fixed  [Benchmark + Portfolio (RS)], [Period Date]:

             SUM( IF [Value] =1 and ( IF [Benchmark / Portfolio] then [Segment Value] = "Open" ELSE [Segment Value] = "Active" END )

              then [BalanceSum] end ) }