5 Replies Latest reply on Nov 30, 2018 5:00 AM by Vijju Vijay

    How to calculate percentage only when budgeted sales and accepted sales are present

    Vijju Vijay

      Hi Community,

       

      I have data with Budgeted sales and accepted sales for current financial year.

       

      Using this data,I am trying to calculate percentage  where budgeted sales and accepted sales data is present.

       

      I have written a calculation it is showing fine when seeing the data in  cross tab but while showing a percentage.it is showing wrong

       

      Can any one help me out on this.

       

      i have attached sample workbook for your reference.

      https://drive.google.com/open?id=1VRJncuc7KKH2vHdQirtX8YOw5kHjs2rs

       

       

       

      Thanks in advance.