2 Replies Latest reply: Sep 27, 2017 4:43 AM by Ahmad Hamdani RSS

    Accumulation Line Chart with null value

    Ahmad Hamdani

      Hello Everyone,

       

      I need to create line chart to compare budget and actual, in actual condition not all date have transaction, sometimes it will blank value. If i show different data with full date were filled with value, the formula works pefectly

       

      I need to show actual result stopped in last date not in end of date.

      Can someone help me..?

       

      Thanks in advance,

      Ahmad

       

      if(sum({<Date_Fix={">=$(=MonthStart(AddMonths(max({<DESC= {'STU'}>}Date_Fix),0)))<=$(=AddMonths(max({<DESC= {'STU'}>}Date_Fix),0))"}, [MODEL GR1]={"*"},year,month,date>}delivery_qty),

      rangesum(

      sum({<Date_Fix={">=$(=MonthStart(AddMonths(max({<DESC= {'STU'}>}Date_Fix),0)))<=$(=AddMonths(max({<DESC= {'STU'}>}Date_Fix),0))"}, [MODEL GR1]={"*"},year,month,date>}delivery_qty),

      above("Del")

      ))

        • Re: Accumulation Line Chart with null value
          Anil Babu

          Try this? Please load and share QVW if possible

           

          Sum(Aggr(if(sum({<Date_Fix={">=$(=MonthStart(AddMonths(max({<DESC= {'STU'}>}Date_Fix),0)))<=$(=AddMonths(max({<DESC= {'STU'}>}Date_Fix),0))"}, [MODEL GR1]={"*"},year,month,date>}delivery_qty),

          rangesum(

          sum({<Date_Fix={">=$(=MonthStart(AddMonths(max({<DESC= {'STU'}>}Date_Fix),0)))<=$(=AddMonths(max({<DESC= {'STU'}>}Date_Fix),0))"}, [MODEL GR1]={"*"},year,month,date>}delivery_qty),

          above("Del")

          )), Date))