Forum Discussion

SebSchoon1's avatar
SebSchoon1
Icon for Post Patron rankPost 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) ...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity 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

SebSchoon1's avatar
SebSchoon1
Icon for Post Patron rankPost Patron
3 years ago

v-jingzhang 

 

Hello sir,

 

It Works now with

 

REP FIN = 

IF([Rank]<>BLANK() && round([reliquat total],0)>=[Rank],1,BLANK())

I think there was an error sooner in my formaulas.

 

I have noticed something else with this.

 

It does not compute the column total, it is strange.

 

Here is the result.

As you can see it works in rows.

 

Then I do  ==> [Partie entière répartition] + [REP FIN] = [Répartition finale]

 

But total should be 13 not 9 .