Crystal 10/Timberline Database
I need help with the below (very lengthy) formula. I have an instance where my "01" number may or may not have a committed cost entry. For instance, cost code "01-710" has a commitment on one job, in which I want that amount to show on the report. On another job, "01-710" may not have a commitment, in which case, I need the report to show the (@Original Budget) amount.
The way the below formula is currently written, instances where there is no commitment entered, it is giving me the correct number, but in instances where a commitment exists, it is adding the commitment amount to the original budget.
I've re-worded this formula every which way I can, and still get the same results. I know basic crystal design, so I'm very limited to troubleshooting.
Any help is GREATLY appreciated!
if{CURRENT_JCT_TRANSACTION.Transaction_Date} <= {?Cutoff Date} and
({CURRENT_JCT_TRANSACTION.Transaction_Type} = "Committed cost" or {CURRENT_JCT_TRANSACTION.Transaction_Type}= "Misc worksheet 1" )
then {CURRENT_JCT_TRANSACTION.Amount}
else if {@Commitment Balance} = 0 and
left(totext({CURRENT_JCT_TRANSACTION.Cost_Code}),2) = "01"
then {@Original Budget}
else if {@Commitment Balance} <> 0 and
left(totext({CURRENT_JCT_TRANSACTION.Cost_Code}),2) = "01"
then {@Original Budget}
Other formulas:
@Commitment Balance =
If {CURRENT_JCT_TRANSACTION.Transaction_Type} in ["Committed cost","Aprvd cmmtt cst chng"] and {CURRENT_JCT_TRANSACTION.Transaction_Date} <= {?Cutoff Date}
then {CURRENT_JCT_TRANSACTION.Amount}
@Original Budget =
IF {CURRENT_JCT_TRANSACTION.Transaction_Type} = "Original estimate"
Then {CURRENT_JCT_TRANSACTION.Amount}
I need help with the below (very lengthy) formula. I have an instance where my "01" number may or may not have a committed cost entry. For instance, cost code "01-710" has a commitment on one job, in which I want that amount to show on the report. On another job, "01-710" may not have a commitment, in which case, I need the report to show the (@Original Budget) amount.
The way the below formula is currently written, instances where there is no commitment entered, it is giving me the correct number, but in instances where a commitment exists, it is adding the commitment amount to the original budget.
I've re-worded this formula every which way I can, and still get the same results. I know basic crystal design, so I'm very limited to troubleshooting.
Any help is GREATLY appreciated!
if{CURRENT_JCT_TRANSACTION.Transaction_Date} <= {?Cutoff Date} and
({CURRENT_JCT_TRANSACTION.Transaction_Type} = "Committed cost" or {CURRENT_JCT_TRANSACTION.Transaction_Type}= "Misc worksheet 1" )
then {CURRENT_JCT_TRANSACTION.Amount}
else if {@Commitment Balance} = 0 and
left(totext({CURRENT_JCT_TRANSACTION.Cost_Code}),2) = "01"
then {@Original Budget}
else if {@Commitment Balance} <> 0 and
left(totext({CURRENT_JCT_TRANSACTION.Cost_Code}),2) = "01"
then {@Original Budget}
Other formulas:
@Commitment Balance =
If {CURRENT_JCT_TRANSACTION.Transaction_Type} in ["Committed cost","Aprvd cmmtt cst chng"] and {CURRENT_JCT_TRANSACTION.Transaction_Date} <= {?Cutoff Date}
then {CURRENT_JCT_TRANSACTION.Amount}
@Original Budget =
IF {CURRENT_JCT_TRANSACTION.Transaction_Type} = "Original estimate"
Then {CURRENT_JCT_TRANSACTION.Amount}