1 Reply Latest reply on Apr 11, 2012 5:53 AM by Alex Kerin

    How to access values of a particular colum from workbook?

    Dinesh Kushwaha

      I have a workbook like:

       

      ServerErrorSuccessError Percentage
      Server11142
      Server20144
      Server32140
      Server40146

       

      Now I have to fill Error percentage column. Itried Calculation field with forumla as:

      If [Error] > 0 then

         [Error] / [Success] * 100

      else

           0

      end

       

      but it not worked & always returning 0.00000 (probably because Error & Success are divison of simple record count from table). In my RnD I found the for formula field Error is never ve more than 0 but from above table you can see it is greater than 0 on couple of instances.

       

      Is there any way to direct access the value appearing on workbook / view?

       

      Thanks.