Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem in implementing the count function.
I am trying to insert an expression in a pivot table. The expression should return the count of glucose values for the glucose values which are less than 100.
I tried using: Count({$<Glucose={'<= 100)'}>}[Glucose])
Could someone help me out? Thanks in advance!
Hi,
Use double quotes for less than or greater than comparison,otherwise it take its whole <=100 to compare as text.
Count({$<Glucose={"<=100"}>}[Glucose])
or
Count({$<Glucose={<=100}>}[Glucose])
Celambarasan
Try that : count ( { <Glucose <=100> } Glucose)
Hi,
Use double quotes for less than or greater than comparison,otherwise it take its whole <=100 to compare as text.
Count({$<Glucose={"<=100"}>}[Glucose])
or
Count({$<Glucose={<=100}>}[Glucose])
Celambarasan