2 Replies Latest reply on May 15, 2018 12:01 PM by Shinichiro Murakami

    Calculation for 2 parameters

    deepthi.dekkala

      Superstore example - I need to display Sales of Particular day which user enters a value in the parameter 1(Enter any day). Another parameter 2(Enter Month) has months(12 Months) in it including 'All'.

       

      Case 1 : When user selects a month, that particular month's last day's sales need to be displayed..

      When selected "All" All month's last day's sale need to be shown.

      If user enters a value in parameter 2(enter any day), then that particular day's sale need to be displayed else if the parameter is blank then last day's  sale need to be displayed in default.

      If user enters beyond 31 ,then any restriction need to be posed here.

       

      Can anyone suggest how to write this calculation.

       

      Thanks in Advance !!