2 Replies Latest reply: Jan 16, 2018 2:27 AM by Justin Pham RSS

    Nested Set Analysis Expression

    Balaji SJ

      Hello People


      I need to build an bar chart for Sum(revenue)/Sum(census) for the previous year. But when i write the below expression, it gives me null values.




      I modified the equation as revenue/census, but i get wrong values for the equation. As it divides row wise revenue by census and sums it.


      Please help me to find the solution to get sum of revenue by sum of census for previous year.