1 Reply Latest reply: Sep 11, 2018 5:22 AM by Stanly Johns RSS

    P&L Reporting with Simulation  using variable

    Stanly Johns

      Hi Community,

       

      Here I'm trying to create P&L report including some variables to simulate different scenarios.

      Here I have the P&L structure configured as shown in the below image.

      P&L Structure.PNG

      What I'm trying to create a table as shown as in the below image.

      Desiered Table

      Simulation Expected Output.PNG

      The expression I have used for calculating [Amount*Variable] =

      aggr(sum(amount),[P&L Layout],[Row No])*sum(pick(match(P&L Lines,Variable),Varaible))

      The resulting table is as shown in the below image.

       

      Current Table

      Simulation output.PNG

      Can anyone suggest any possible solution to solve this problem?

      Any help is greatly appreciated.

       

      Thanks in advance.

       

      Stanly