Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

ISBLANK in IF

Hi,

 

I have a measure (""Real_Orders" - connected with Database, future dates do not have a value) and a column ("Target_Orders" for each date in the next 6 months) and I want to subtract them, but only if "Real_Orders" are not empty. If there are no orders tracked (future dates), the subtraction should be 0.

 

I tried it like this:

IF(ISBLANK([Real_Orders]);0;([Real_Orders]-SUM(Target_Orders)))

 

Unfortunately it doesn't work and it seems that he is not replacing the subtraction with 0.

 

Thanks in advance.

Micha

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    v-jiascu-msft

     

    Thank you for your help.

    I solved it now a different way. I just filtered all future dates an subtract real orders with target orders.

     

10 Replies

  • dedelman_clng's avatar
    dedelman_clng
    Community Champion
    9 years ago

    Depending on how your [Real Orders] measure is created, you may need to test on [Real Orders]=0 instead of BLANK().

     

    Hope this helps.

    David

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Unfortunately not. It's the same.

      The measure (real_orders) is based on DISTINCTCOUNT.