x Want to participate? Join the group to interact

Sage 100

Reporting and Analytics Sage intelligence add functions

Sage intelligence add functions

Posted By KathyW 5 months ago

SI has a function for "GLActual" that nets the debits and credits.

Is it possible to add 2 different functions to get the debit and credit separately?

the data exists in the actuals currently included sub report.

Parents

0 Debbi_S 5 months ago

I use 2 columns

In the debit column =if(GLActual.....)>=0,GLActual(...),o)

in the credit column =if(GLActual.....)<0,GLActual(...),o)
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel

Reply

0 Debbi_S 5 months ago

I use 2 columns

In the debit column =if(GLActual.....)>=0,GLActual(...),o)

in the credit column =if(GLActual.....)<0,GLActual(...),o)
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel

Children

No Data