6 Replies Latest reply: Sep 26, 2011 8:56 AM by Dennis Hoogenboom RSS

    How to capture null value in following example

    Kamal Naithani

      Hi Friends

                       I am using the four fields as Revenue,Expenses,Tax and Year in the table.

                       We are using a expression Income as (Revenue -Expenses-Tax) ,there is one null value in tax.What i want is that when we run a loop and as it identify the null value,the loop breaks and calculate the income for the data before the null value and will show the income for the data after the null value as 0.

      I am attaching my excel sheet with this.

       

      Thanks in advance