Hi,

Create a Calculated Column in SharePoint with the formula:
=[Price]<10
This will create a column that will output Yes Or No depending if the value in the Price column is more or less than 10.

On the form add a Calculated Value control with the formula:
count(lookup("Shopping", "LessThanTen", true, "ID",true))
This will look up a list called Shopping and search for all the entries in the Calculated column which I have called LessThanTen and return an array of ID's which are then counted and displayed.

Note: Even thou the column outputs Yes and No this is actually a Boolean and that is why true is uses in the formula instead of Yes for the filter.

Note2: As the lookup can only return a maximum of 1000 items this function will be limited to that.

---

Hi Simon, Thanks for your reply. Please note less than ‘10’ above is used as an example. To clarify it is a variable. Depending on what a user enters a value in one of the previous fields within the form, this 10 can be either 15 or 65 or any other number. For e.g.: When user enters 5, It should show the count of grocery items which has price less than 5 and if he enters 15, it should show the count of items which has price less than 15.

---

The solution provided counts up how many items match the criteria which was how many items are less than 10. This was done by using a SharePoint column calculated field. As this feild cannot be altered by a form my solution will not work based on your new requirement and I am not sure how you could acheive this. It may not be possible to acheive this solution without Javascript and a Classic Nintex form.

---