3 Replies Latest reply: Mar 27, 2018 5:32 AM by Yan Foust RSS

    Calculated measure doesn't display correctly in chart

    Yan Foust

      Hi,

      I've written an expression to filter data. The resulting data is correctly displayed in a table but if I copy the expression to a chart measure, is not displayed correctly.

      Here is the expression I am using

       

      =IF([Contract end date]-[Contract start date]=0,(([Opportunity amount]*[Opportunity probability percentage])/100),

      IF((Date((MonthStart(today())+365), 'DD/MM/YYYY')

      -Date(Date#([Contract start date],'YYYYMMDD'), 'DD/MM/YYYY'))/30

      *Sum(([Opportunity amount]*[Opportunity probability percentage])/100)

      /SUM((Date(Date#([Contract end date],'YYYYMMDD'), 'DD/MM/YYYY')- Date(Date#([Contract start date],'YYYYMMDD'), 'DD/MM/YYYY'))/30)<=0,0,

      (Date((MonthStart(today())+365), 'DD/MM/YYYY')

      -Date(Date#([Contract start date],'YYYYMMDD'), 'DD/MM/YYYY'))/30

      *Sum(([Opportunity amount]*[Opportunity probability percentage])/100)

      /SUM((Date(Date#([Contract end date],'YYYYMMDD'), 'DD/MM/YYYY')- Date(Date#([Contract start date],'YYYYMMDD'), 'DD/MM/YYYY'))/30)))