topic Re: REP04 Employee Expense Summary Formulas in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/REP04-Employee-Expense-Summary-Formulas/m-p/87474#M19350
<P>can you plzz share the correct formula</P>Wed, 14 Oct 2020 18:09:09 GMTakankshaschavan2020-10-14T18:09:09ZREP04 Employee Expense Summary Formulas
https://community.anaplan.com/t5/Anaplan-Platform/REP04-Employee-Expense-Summary-Formulas/m-p/82685#M18013
<P>I am trying to develop calculation formulas for the REP04 Employee Expense Summary, but keep receiving errors and incorrect numbers. I posted each of my attempts with screenshots of formulas and results below and would like guidance in developing the appropriate calculation formula.</P><P> </P><P>First Attempt (1A): Created a basic formula importing data from the EMP02 Employee Expenses module, but each region has the same expenses between each other.</P><P>Second Attempt (2A): Added to the formula including region and department, but calculation is invalid. I have tried referring to different modules and receive errors as well.</P><P> </P><P> </P>Fri, 04 Sep 2020 23:46:24 GMThttps://community.anaplan.com/t5/Anaplan-Platform/REP04-Employee-Expense-Summary-Formulas/m-p/82685#M18013vciarami2020-09-04T23:46:24ZRe: REP04 Employee Expense Summary Formulas
https://community.anaplan.com/t5/Anaplan-Platform/REP04-Employee-Expense-Summary-Formulas/m-p/82702#M18020
<P>Hi <LI-USER uid="38796"></LI-USER> </P><P> </P><P>REP04 Employee Expenses Summary is the aggregated sum for Region and Role. Use SUM in your formula in place of LOOKUP.</P><P> </P><P>Regards,</P><P>Srikanth</P>Sat, 05 Sep 2020 10:23:23 GMThttps://community.anaplan.com/t5/Anaplan-Platform/REP04-Employee-Expense-Summary-Formulas/m-p/82702#M18020SrikanthKamath2020-09-05T10:23:23ZRe: REP04 Employee Expense Summary Formulas
https://community.anaplan.com/t5/Anaplan-Platform/REP04-Employee-Expense-Summary-Formulas/m-p/83096#M18132
It works, thank you!Tue, 08 Sep 2020 21:09:31 GMThttps://community.anaplan.com/t5/Anaplan-Platform/REP04-Employee-Expense-Summary-Formulas/m-p/83096#M18132vciarami2020-09-08T21:09:31ZRe: REP04 Employee Expense Summary Formulas
https://community.anaplan.com/t5/Anaplan-Platform/REP04-Employee-Expense-Summary-Formulas/m-p/87474#M19350
<P>can you plzz share the correct formula</P>Wed, 14 Oct 2020 18:09:09 GMThttps://community.anaplan.com/t5/Anaplan-Platform/REP04-Employee-Expense-Summary-Formulas/m-p/87474#M19350akankshaschavan2020-10-14T18:09:09Z