We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

FRS Reports challenges (IF formula and showing 2 Parent account values in single column)

Accepted answer
1
Views
1
Comments

Summary:

FRS Reports challenges (IF formula and showing 2 Parent account values in single column)

Content (required):

Hi All,


We have below challenges in FRS Report development.. Kindly let me know if anyone has come across this kind of requirement


1. Can we achive below mentioned formula in FRS Report ina single column ?


if(CM=0,PM<0),100%,

else if(CM=0,PM>0),-100%,

else if(PM=0,CM<0),-100%,

else if(PM=0,CM>0),100%,

else if(CM=0,PM=0),0,

else if(PM<0),-(CM-PM/PM)%


*CM - Current Month

*PM - Previous Month


2. We need to display multiple Natural Accounts and Cost Center Values in Single column (Ex: Parent 400000 and Parent 500000) dynamically

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!