Drill to transaction on module with versions – tip
Hi everyone, I thought I'd share a something useful I recently discovered, which I haven't seen documented anywhere.
According Anapedia, Drilll to Transaction is only supported for formulas like TransactionModule.Amount[SUM:___, SUM:___]
So this means that you can't drill to transaction on a formula like IF ISACTUALVERSION() THEN TransactionModule.Amount[SUM:___, SUM:___] ELSE complicated formula
And that's generally true, but I've found it does work for this specific type of formula: IF ISACTUALVERSION() THEN TransactionModule.Amount[SUM:___, SUM:___] ELSE COLLECT()
I hope some of you find this helpful too!
Will
Comments

Hi Will,
is the collect() part really necessary ?
0 
Hi Nathan,
The idea is that you can do a complex calculation for your nonactual versions in a separate module. Then you can use a line item subset and the collect() function to pull those amounts into the first module. So you end up with a reporting module that contains actuals and forecast, and allows users to drill to transaction for the actual version.
Thanks
Will
0 
you mean if I do a look up in my other module and collect it, the user can drill to transactions on it because of the collect ?0

Hi Nathan,
Not quite – if you have a select in your other module, and then pull it in with a collect like this:
ISACTUALVERSION() THEN TransactionModule.Amount[SUM:___, SUM:___] ELSE COLLECT()
... then users can drill to transaction on any ACTUAL periods, but not on FORECAST periods. The point being, if you tried to use a formula like this:
IF ISACTUALVERSION() THEN TransactionModule.Amount[SUM:___, SUM:___] ELSE complicated formula involving SELECT
... then users would not be able to drill to transaction on any period at all.
Thanks
Will
0 
ok I get it. Interesting. will look further into it, if it is intended or not.0