2 Replies Latest reply on Jan 19, 2017 9:01 AM by Yuriy Ovchinnikov

    % of total for calcuated field

    Yuriy Ovchinnikov

      Hi there!


      I am doing some simple calculations, sort of LOOKUP(SUM([Amount]),-5)-LOOKUP(SUM([Amount]),-4) for which i create cal.fields.

      I got my results as absolute values, but couldnt get it as percentages.


      I want to compute % of total for ending results. (ending result for item A / total ending result for all items)


      To illustrate this I enclosed the workbook.

      Where I have revenue and cost for 5 brands. By using lookup calculation I've got the net revenue (which is revenue - cost) and now I want to have percentage of each brand represents in total net revenue.


      Sounds simple, but I'm in frustration.

      Thank you!