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 days. Result for those days should blank.

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

     

     

3 Replies

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