P& L Account

[upaliwije]

Hi Friends

I Have created a P&L account using Interval Match Concept explained in

• See this blog post: How IntervalMatch Solved My Profit and Loss Dilemma

There you get following figures

Gross Sales              10000

  Sales Returns          -1000

  Invoice Discount      -  500

  Sales Promoton       -1000

Net Sales                  7500

In my data table above minus figures are recorded as positive figures but the Net sales should be Rs.7500/- How can I do the modification to data model to solve this problem . Pls help

[trdandamudi]

Is it possible to multiply Sales Return, Invoice Amount and Sales Promotion with -1 ? so that you get the desired result...

[#3]

Hi. We solved a similar problem for a p&l report by adding an extra field in the the p&l format table which indicated the sign for the specific row, i.e. 1 against all positive rows and -1 for all expense rows…something like:

P&L Header                     Sign

Net Sales                              1    

Sales Return                         -1

Invoice Discount                    -1

…..

Then in the chart expression just multiply with Sign field….

sum(…..Amount)*(Sign)