Forum Discussion
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) ...
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
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 .