Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

not equal operator not filtering

I  am trying to calculate a measure using below formula , But its not filtering properly   NOT EQUAL OPERATOR<> Not giving desired output   Please advice thanks  Franchise = CALCULATE( SUM('Mode...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago
    Also is your number formatted as Text or Whole Number, Decimal Number or Fixed Decimal Number? As that could then also affect the <>

GilbertQ's avatar
GilbertQ
Super User
9 years ago
Also is your number formatted as Text or Whole Number, Decimal Number or Fixed Decimal Number? As that could then also affect the <>

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks for your help GilbertQ it worked when I changed data type of parent id,  FROM TEXT TO WHOLENUMBER

 

Thanks

Mazhar

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago
    Great that you got it working