fastr report question

[bigbubu]

Currently we have report looks like below. we have two cloumns one is based on AA LT and the other is based on UC LT

account# totalAA totalUC
1 5 8
2 6 7
3 9 10
4 11 12

ideally we want to change to just using one column some account use AA, some use UC

account# total
1 5
2 6
3 10
4 12


is it doable in Fastr?

Thanks

 

[Alex Blasenheim]

I haven't worked with FASTR in quite a while but I believe the answer is yes. I recall doing this. It might have been 1)the override cell feature or 2) using the third column as a hidden column and somehow negating the value of the 2nd column/row and adding the 3rd column/row or 3) created a 3rd ledger using a combination of index allocations pulling values from AA and the 2nd ledger then running the FASTR off the 3rd ledger. Let me know how you make out.