13 Replies Latest reply on Dec 14, 2016 10:00 AM by hetal joshi

    Division and Calculated field problem

    hetal joshi

      Hi,

       

      I have two raw data tables with Visitor Information from three countries for three months

      RawDataA: Visiting_Month, Transporation_Mode, Visitor_Name, Country_Name

      RawDataB: Visiting_Month, Transportaion_Mode, Total_Visitor_Count

       

      Joining fields: Visitng_Month, Transportaion_Mode

       

      I want to create a calculated field showing Visitor Rate for each month.

       

      Formula for Visitor Rate = CountD(Visitors)/Sum(Total_Visitor_Count)   ---- (In excel)

       

      In order to get Visitor Rate I created two Calc. fields with LOD expressions

      LOD1: {FIXED [Mode]:COUNTD([Visitor])}

      LOD2: { FIXED [Mode] :SUM([Visitor Count])}

      In third calculated field using a DIV(LOD1, LOD2)

       

      But it gives me 0. I definitely am doing something wrong here.

       

      Any  guidance would be appreciated.

       

      Workbook and sample chart required attached.