Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

How to hard code SALES_ Field with amount is not zero ?

Hi All I have a chart witht eh help from Anonymous  , ailsa advise me add filter panel with sales is not 0 , it work fine. now i like to hard code this into my SALES_ Field :- I have try :- ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Revised your target measure to:

    TARGET_ = if(ISBLANK([SALES_]),BLANK(),SUM(TARGET_[TARGET]))

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

You are welcome.