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()
      )

     

     

TomMartens's avatar
TomMartens
Super User
9 years ago

A quick solution would be to put your calculation into an if statement, that checks if your measure is not null like this

 

IF(NOT(ISBLANK(sum of your measure)), your calculation, BLANK())

 

You have to consider that this formula also surpresses the calculation for days where there is no data, for a business reason.

  • 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()
        )