Hey there. I'm trying to make an expression that adds an expression to a value. The column that I have is called TERRITORY NO. It always has a single number in this column on my sheet, for example 6. But in my app, I want it read as Territory 6 (20 Left) in my Data Entry view only. This count goes down every time a check mark is added.
In my app, all of the data is grouped by Territory No. So this feature is handy for data entry. I'm trying to use in place of the Group aggregate (since we can't make our own Group aggregate expression). I tried this in the initial values section of my TERRITORY NO. column. Everything worked but it didn't display the number.
Not sure where to put the expression or if it is even possible.
CONTEXT("View")="Data Entry ",
"Territory"
& [TERRITORY NO.]
&" ("(COUNT(select(Database[ID #],true))-COUNT(select(Database[ID #],[CHECK]="Yes")))
&" "Left")"
LinkedIn
Twitter
