Incorrectly calculated Week
Fred
On Choice (Dynamic ) I use the formula
let l := '1N_Control Issues';
l[let t := Week;
first(l[Week = t]) = this] order by Week
Copy
And on the View I use the formula
let s := record('Control Issues',number('Choice Rev A')).Week;
'1N_Control Issues'[Week = s]
Copy
On '1N_Control Issues' the weeks are OK and 'Control Issues' the weeks is ok too.
What is wrong.
6 replies
-
Rafael said:
On '1N_Control Issues' the weeks are OK and 'Control Issues' the weeks is ok too.
What is wrong.I'm not sure what the problem is if you say everything is OK.
-
Rafael said:
if you see the first image the Date it does not match with the Week.I saw the image, but it looks right to me. You only asked to match Week so since you selected 17 in the dC field only records with week = 17 showed up in the View element. I don't know how you got the 17 in the week field so you will have to figure out what is going on in the 'Control Issues' table.
-
Fred The Table 'Control Issues'.
I thinks the problem is there are there colums Rev dates and the formula no has reference for each column Date.
I thinks need changed this Formula so you know What revisión is
let s := record('Control Issues',number('Choice Rev A')).Week; '1N_Control Issues'[Week = s]
-
-
Rafael said:
The Table 'Control Issues' apparently Look good.Are '1N_Control_Issues' and 'Control Issues' the same table?
You need to see why those 6 records in '1N_Control_Issues' are showing up when you search for Week 17, but have dates that don't match.
What is the code in Week?
Content aside
- Status Answered
- 11 mths agoLast active
- 6Replies
- 62Views
-
2
Following