Forum Discussion

mrslyfox's avatar
mrslyfox
Helper II
9 years ago
Solved

TOTALMTD empty days

Hello,   Have a folowing formula MTD Sales:=TOTALMTD(SUM(F_Delivery_Note[DELNL_TotalGrossSqm]),D_Date[LINK_Date])   Which gives me almost expected results. Trouble only with last marked by red ...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    Hey

     

    your formula should look like this

    MTD Sales:=IF(
     NOT(
      ISBLANK(
       SUM(F_Delivery_Note[DELNL_TotalGrossSqm])))
       ,TOTALMTD(SUM(F_Delivery_Note[DELNL_TotalGrossSqm]),D_Date[LINK_Date])
       ,BLANK()
      )

     

     

mrslyfox's avatar
mrslyfox
Helper II
9 years ago

Hello TomMartens

 

Result of

MTD Sales:=IF(NOT(ISBLANK(TOTALMTD(SUM(F_Delivery_Note[DELNL_TotalGrossSqm]),D_Date[LINK_Date]))),TOTALMTD(SUM(F_Delivery_Note[DELNL_TotalGrossSqm]),D_Date[LINK_Date]),BLANK())

 

returned the same result as it was from the beginning.

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey

 

your formula should look like this

MTD Sales:=IF(
 NOT(
  ISBLANK(
   SUM(F_Delivery_Note[DELNL_TotalGrossSqm])))
   ,TOTALMTD(SUM(F_Delivery_Note[DELNL_TotalGrossSqm]),D_Date[LINK_Date])
   ,BLANK()
  )