Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Trying to build a more complex expression for a KPI.
I want to only count the number of rows of apple in the "fruit" column if the amount is 5 or more.
So I like to see Apple count is 2 because there is 2 apple rows where the amount is 5 or higher. My expression is just not working.
Here is my expression:
Count({$<[fruit]={"Apple"}>,[Amount]={">5"}>})
It tells me there is an error in my expression: '}' expected, What does that mean. data below. Thanks.
Try like:
Count({$<[fruit]={'Apple'},[Amount]={">=5"}>} fruit)
Few corrections are made that are highlighted and removed one extra '>'. Also check and make necessary change if your field names are correct, i.e. - 'fruit' and 'Fruit' are different.
Try like:
Count({$<[fruit]={'Apple'},[Amount]={">=5"}>} fruit)
Few corrections are made that are highlighted and removed one extra '>'. Also check and make necessary change if your field names are correct, i.e. - 'fruit' and 'Fruit' are different.
Thank you Tresesco! It worked.