Linktofilteredview and formatting

Hi Guys
With a LINKTOFILTEREDVIEW I am applying a format:

But the results are the same for every row:

How could this be and what would the fix be?

Cheers

0 6 364
  • UX
6 REPLIES 6

We canโ€™t see EmpEfficiency. What data type is it?

The name and usage of โ€œ100โ€ in the expression makes me think its Percent? If so, you need to base your criteria off of the raw value stored in the sheet. Usually that means that 100% is stored as 1.00. So change the expression to โ€ฆ< 1.0

Hi, EmpEfficiency is not shown on the table view but is there in detail view, the column is set at Number so the values are at One Hundred Percent Efficiency shown as 100 numerically without the percentage fraction.

2X_7_72406569a684ef9725d97c4bd08929c9521d738d.png

2X_9_9ae86b2e8660164edeb2ddca6fb56fadc5327614.png

So I canโ€™t understand why it should fail.
I was thinking it was that way because of the filtered view ??

Well,something is definitely wrong: Number values donโ€™t have decimal points.

@Steve is correct, your sheet data doesnโ€™t match the data type defined in AppSheet.

However. I played with a little same app and AppSheet should be able to cope. Here is my sheet sample data:

2X_1_1361e7e2d10154c0c3e6ff1fede2f4ba663e9cad.png

In AppSheet these values were shown like this:

2X_3_3678d9a4ee354562eae614e3025ea1fae7113284.png

and I used this format rule:

Your current implementation should work. The decimal number will round to nearest whole number. The result of the format rule will be based on the rounded number.


I guess what we havenโ€™t seen is the rest of your format rule to see what format(s) you are trying to apply. Also, make sure there are not OTHER rules that are interfering.

I think its because of the relationship between tables.

qryEffFinal and qryEfficiencyCore both have the correct key fields [EmployeeID] in Number format.
In qryEffFinal there is one entry of [EmployeeID] for each member of staff.

2X_9_9116fac2a2fb341c78219f71ab1a0830839413c1.png

In qryEfficiencyCore there are many entries for [EmployeeID].

2X_8_80f3b9a8594228d06898a70d7c439a4d3cdccec4.png

These are shown from:
LINKTOFILTEREDVIEW(โ€œJobDetailโ€,[EmployeeID]=[_THISROW])
But, if I select a record from here then the record shown isnโ€™t the one I selected.
Example:
If I select this record:

2X_4_472446f6ff2d9ae88fe5631ef04af42b756e062e.png

Which shows 20.00 and 19.24, the record shown is as follows:
2X_3_3500ee777d69dcbef461302d946fcf3627d7bfe3.png

Which has 5.50 and 5.25

So there is something wrong with the filter ???

Change [_THISROW] to [_THISROW].[EmployeeID]

Top Labels in this Space