10 Replies Latest reply on Oct 3, 2013 4:14 PM by Luigi Cicciari

    Sorting on Calculated Fields

    Luigi Cicciari

      Hello Everyone,


      I am building a workbook that mashes two excel workbooks together. The first has a list of buyers names and the stores they are assigned to. The other is the amount of spending for each store and the amount of leads generated. I am running into issues with using sorting within the view.


      In order to display null values as "0" I utilized ZN formulas (e.g. ZN(lookup(sum([Leads]),0))).  


      What can I do to allow the calculated fileds to be sorted? In this case Spending, Leads, & Cost Per Lead?


      Please see the attached sample.


      Thank you in advance for your help.