You are correct that any RT that is NULL will NULL out any formula that adds them together. A work around is to use multiple if thens.
(if isnull({#RT1}) then 0 else {#RT1}) + (if isnull({#RT2}) then 0 else {#RT2}) + (if isnull({#RT3}) then 0 else {#RT3}) + ...
Here are a couple of soultions for your issue (hopefully).
Group on DED Code, make your RTs as you have them and place them on DEDCODE group footer then do a insert sumamry as SUM(DED-AMOUNT,DEDCODE) and place it on the DEDCODE-GRoup Footer for your YTD amount. This is the amounts per Dedcode. (If you want all the Dedcodes at once then make a formual field as SUM(DEDcode).)
You could also make a Crosstab (this assumes you do not have more than 1 year of data, if you do you have to adjust for that).
Create a formula to get your Month names:
Monthname({Command.CHECK-DATE},abbreviate)
Add a Crosstab in the RH or RF
In the CT Expert Columns is the new Month Formula you just made
Rows is the DedCode field
Summarized field = Ded Amount
Edited by DBlank - 20 Nov 2009 at 7:07am
IP Logged
