4 Replies Latest reply on Aug 19, 2016 8:45 AM by mohamedferozkhan.m

    Calculated Field Based on the Dimension Not showing




      I am have following data and created two calculated field based on the Dimension . Then created one more field adding two calculated field fields. The third calculated field not showing anything. Any idea why it is not showing. Please help



      1. Cash on Hand LCY = If [Asset Type1]="Cash On Hand" then [Local Currency] END

      2. Claims on Bank LCY = if [Asset Type1]="Claims on Bank" then [Local Currency] END

      3. COH_COB = [Cash on Hand LCY]+[Claims on Bank LCY]