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.

       

      Luigi