on 06-23-2016 3:35 PM
Hi,
Hoping someone can assist with a query regarding implementing cross package controls within the category. I've been asked to create controls that measure the value against an account within one package with the value of a different account in another package. I've attempted numerous versions of both the Factor and Expression within the control and I can get the system to accept the control. However, when I atempt to validate the package the control is rejected due to invalid settings.
I'm currently using one RU as the Factor, detailing both accounts and using the "AND" command to incorporate the second RU.
Any help would be appreciated.
Thanks.
Hello Scott,
I would use the following syntax, assuming inputs are done on the same flow (Fxx) for both accounts :
Factor
{FL = Fxx}
Expression
IF ([RU = RU1] ; {AC = AC1} = {AC = AC2 ; RU = RU2}) AND IF ([RU = RU2] ; {AC = AC2} = {AC = AC1 ; RU = RU1})
Please note that both packages must be keyed in in the same reporting currency.
Regards.
Olivier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.