3 Replies Latest reply: Nov 15, 2013 7:26 AM by Ivan Gadzhonov RSS

    very tricky - calculation based on base KBIs

    Ivan Gadzhonov

      Hi all,

       

      Here I have

      ID- id of KBI

      name - name of the KBI

      calculation - formula how to calculate the KBI

       

      IDnamecalculation
      16a([100017]/[100013])
      17b(([100001]+[100002]+[100003])/[100013])
      18c([100001]/([100023]*[100004]))
      100023d[100023]
      100004e[100004]
      19f([100023]*[100004])
      100018g[100018]
      100017h[100017]
      100013i[100013]
      100001j[100001]
      100002k[100002]
      100003l[100003]

       

      Now I want to calculate kbi-s 16,17,18, 19   using the formula in 'calculation' field. This calculation has to be in the layout because every base kbi - ID filed - has in the Database its Numerator and Denominator that's why I have to calc all the kbis in the layout

       

      Any suggestions how to do it?

      Thanks in advance!