FRS Reports challenges (IF formula and showing 2 Parent account values in single column)
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
Tagged:
0