Forum Discussion

jsanchez8's avatar
jsanchez8
Regular Visitor
3 years ago

Measure Column displaying True even though its False

Hi,

 

I have a table that contains projects, and there respective gross, reimbursement and subs. I created a Has Revenue  measure that checks if the values in each of the columns values and sets the Flag to 1 if it has amount not equal to 0. However, it is only working on columns that are blank and not columns that have 0. I have attached a screenshot of this below. 

 

 

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    jsanchez8 Try blowing your decimal places out to 10 digits and see if perhaps there is some small decimal amounts for those 0 values.