Hi , Could you please help me to populate the value for Calculated_implentation_date.
Logic as
if the implementation_date exists,
then implementation_date
else
for that assumption_key, get the implementation_date for phase 1 and do this formula
AdjustYear([implementation_date],([phase]-1)
So my final answer should have the Calculated_implentation_date as below
10 2 <null> 05-30-2019
10 3 <null> 05-30-2020
10 4 <null> 05-30-2021
Question
How do I fetch value from similar record
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.