NEWBIE - Crystal 10, Timberline 9.2
I have this very basic formula to look up the amount for "Percent Complete". However, this may have more than one value, so I need to pick the value that has the most recent transaction date, but I'm not sure how to word it.
if {CURRENT_JCT_TRANSACTION.Transaction_Type} = "Percent complete"
then {CURRENT_JCT_TRANSACTION.Amount}
Thanks,
H
I have this very basic formula to look up the amount for "Percent Complete". However, this may have more than one value, so I need to pick the value that has the most recent transaction date, but I'm not sure how to word it.
if {CURRENT_JCT_TRANSACTION.Transaction_Type} = "Percent complete"
then {CURRENT_JCT_TRANSACTION.Amount}
Thanks,
H