jizzycrystal
IS-IT--Management
Hi
I'm trying to add two formulaes:
{@Prior YTD amt} + {@PriorYTDkfBUD}
@Prior YTD amt:
IF {nltran15zeverydb.trans_period} >= "01" and {nltran15zeverydb.nlyear} = "14" THEN {nltran15zeverydb.journal_amount}
else IF {nltran15zeverydb.trans_period} >= "02" and {nltran15zeverydb.nlyear} = "14" THEN {nltran15zeverydb.journal_amount}
else IF {nltran15zeverydb.trans_period} >= "03" and {nltran15zeverydb.nlyear} = "14" THEN {nltran15zeverydb.journal_amount}
@PriorYTDkfBUD:
IF {?ytd_period} = '01' then {bud15_1.base_amount01}
else if {?ytd_period} = '02' then +({bud15_1.base_amount01} +{bud15_1.base_amount02})
else IF {?ytd_period} = '03' then ({bud15_1.base_amount01} +{bud15_1.base_amount02} + {bud15_1.base_amount03})
getting the above error
I have tried using running totals and also sum but still getting same error
Can anyone help?
Thanks
Jizzy
I'm trying to add two formulaes:
{@Prior YTD amt} + {@PriorYTDkfBUD}
@Prior YTD amt:
IF {nltran15zeverydb.trans_period} >= "01" and {nltran15zeverydb.nlyear} = "14" THEN {nltran15zeverydb.journal_amount}
else IF {nltran15zeverydb.trans_period} >= "02" and {nltran15zeverydb.nlyear} = "14" THEN {nltran15zeverydb.journal_amount}
else IF {nltran15zeverydb.trans_period} >= "03" and {nltran15zeverydb.nlyear} = "14" THEN {nltran15zeverydb.journal_amount}
@PriorYTDkfBUD:
IF {?ytd_period} = '01' then {bud15_1.base_amount01}
else if {?ytd_period} = '02' then +({bud15_1.base_amount01} +{bud15_1.base_amount02})
else IF {?ytd_period} = '03' then ({bud15_1.base_amount01} +{bud15_1.base_amount02} + {bud15_1.base_amount03})
getting the above error
I have tried using running totals and also sum but still getting same error
Can anyone help?
Thanks
Jizzy