0 Replies Latest reply: Mar 16, 2016 2:47 PM by Brian Heberlein RSS

    Percent of Revenue in a P&L

    Brian Heberlein

      I've created a P&L within Qlikview following the standard interval match P&L development format.  The next step is that I am trying to have the next column represent the percent of revenue, but am unable to get the column to completely fill out as can be seen in the attached image.  The percentages are correct for the places where they are filled out, but I need to have the percentages for all the items shown (product cost, volume rebates, etc.).  My percent formula is: =If([Exec P&L Heading] <> Null(),If([Exec P&L Level] = 's',' ', sum([Amount]))) / sum({$<[Trending]={'Revenue'}>} [Amount])

       

      Any thoughts on why percentages are not all filling out would be much appreciated.

       

      P&amp;L.jpg

       

      Thank you in advance for any help.