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.

       

      =Sum({$<Year={"$(=Max(Year-1))"}>}(Sum(revenue)/Sum(census))

       

      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.

      =Sum({$<Year={"$(=Max(Year-1))"}>}revenue/census)


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


      Thanks

      Balaji