Forum Discussion

SebSchoon1's avatar
SebSchoon1
Post Patron
3 years ago

wrong measure result

Hi guys,

 

I do a measure Asking if  The value in a column is equal to 2 and it only send information for some data not all.

 

here is my formula

 

REP FIN = if([reliquat total]=2,1,0)

why is this not working?

 

here is my link

 

https://we.tl/t-fHRehqwIvv

 

Need Help

4 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    I am not sure whether I correctly understood your datamodel, but could you please try the below?

     

    REP FIN =
IF ( ROUND ( [reliquat total], 0 ) = 2, 1, 0 )
    • SebSchoon1's avatar
      SebSchoon1
      Post Patron
      3 years ago

      Hello ^^

      Jihwan_Kim 

       

      it does not work

       

      What i need is to allocate one quantity to eache warehouse which have a Rank Less or equal to [Reliquat total]

       

      But it does not work 😞

       

      your solution provide me 1 everywhere i think i uses the Total value of Reliquat total

      • v-jingzhang's avatar
        v-jingzhang
        Community Support
        3 years ago

        Hi SebSchoon1 

         

        According to the description, do you want to compare the value in Rank and the value in Reliquat total? Can you please explain the expected result you want to achieve based on the current sample data?

         

        Best Regards,
        Community Support Team _ Jing