-
1. Re: Calculate MIN date with some spicy problems
Deepak Rai Oct 24, 2017 9:53 PM (in response to Justin Pulley)-
Minimum Dates.twbx 29.1 KB
-
-
2. Re: Calculate MIN date with some spicy problems
Deepak Rai Oct 24, 2017 9:55 PM (in response to Justin Pulley) -
3. Re: Calculate MIN date with some spicy problems
Zhouyi ZhangOct 24, 2017 9:56 PM (in response to Justin Pulley)
-
min date sample.twbx 29.8 KB
-
-
4. Re: Calculate MIN date with some spicy problems
haitham Farouk Oct 24, 2017 10:17 PM (in response to Justin Pulley)Hi Justin
see the below image:
The first column contain the start date as in your data the second column is correction based on the logic you mention ...
I used pan level table calculation to compare the value with the first row in the pan if less it display the first row in pan, else it display the MIN date in pan ... (You can see the calculated field formula in the image)
Hope this fulfill what you looking for, and you find it correct or helpful.
Best Regards
-
5. Re: Calculate MIN date with some spicy problems
Justin Pulley Oct 24, 2017 10:25 PM (in response to Deepak Rai)@Deepak Rai
Not quite right; you see where step one was 10/31/2014 on P2? well your formulas are changing step 1's dates to the April date. That is not correct. Step 1's date should never change. It is the reference date. so in P2 Step 3 the date should change to 10/31/2014 without changing the date for Step 1, step 1 should remain 10/31/2014.
-
6. Re: Calculate MIN date with some spicy problems
Deepak Rai Oct 24, 2017 10:41 PM (in response to Justin Pulley)-
Minimum Dates.twbx 29.0 KB
-