Search results

I am trying to use the Lookup function to retrieve the description form the table tCodes and apply the description value in the description box in the form tDes with the After Update For example if the users types any number between 100 and 199 in the Code field, the Description is...

I think I answered my question...:eek: if(greater(item()?['Days'], 0),1, 0)

I need the correct formula to count the items from a Get items, I need to count those records where Days is greater than 0. I have a variable TotCount with the he expression: if(greater(item()?['Days'], 0), 0, 1) The above code always returns 0, below are a few example of what I need: Days...