Skip to Content

EPM Comparision function ,results sign display for Assets and Liability Accounts?

Dec 13, 2017 at 06:43 PM


avatar image
Former Member

Hi BPC Folks,

Please advise on the below information.

In BPC 10.1 Classic on HANA DB with EPM SP28 version,

For example in EPM Comparision(Account123 ,A1 ,B1) function result sign is based on Account Type of Account123 , what would be the sign displayed in report if Account123 of Type either Assets or Liabilities . As we are aware of sign displayed is positive if Account type is REV or INC and negative if the type is EXP .

Thanks and Regards,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Dec 13, 2017 at 06:58 PM

What do you mean by: "Account type is REV"???

ACCTYPE can be only: INC, EXP, AST, LEQ

Please test yourself the results of =EPMComparison(,"Account",A1,B1) for different account types and provide a screenshot of the question!

10 |10000 characters needed characters left characters exceeded