Skip to Content
0
Aug 23, 2012 at 12:51 AM

Flip account sign in Trial Balance report - BPC NW10

430 Views

Hello,

I am building a Trial Balance reprort with ACCOUNT detail in Row Axis and ENTITY detailed in Column Axis.

I need to reverse the sign of data from the native sign stored in BPC, depending on the ACCTYPE (if ACCTYPE = INC or LEQ, then reverse sign in the report).

This is easy to using an EPMMemberProperty combined with an IF formula..

However, when the report has the ENTITY accross (in Column Axis), I don't know how to do.

Have you ever build something like this?

Thanks,

Eleonore