1 Reply Latest reply on Aug 2, 2018 12:05 PM by Deepak Rai

    Calculation of proportions at different levels of detail and views

    Mitchell Hensman

      Dear community,

       

      I'm stuck on a few problems but I think they can all be traced to no knowing/understanding how to work out what proportion a particular value is of a whole. For example, if I have various statuses (say 'compliant' and 'non-compliant') for a range of project criteria, how can I work out what proportion is 'compliant' or 'non-compliant'.

       

      I've successfully used table calculations when the view is showing the same quantity, but when I try and write a calculation (using LOD functions) for my self-defined quantity I get an error saying that I can divide/multiply fields at different levels of detail.

       

      Can anyone help?

       

      Thanks,

       

      Mitch