Skip to main content
Solved

How to take Profit and Loss report figure in Dashboard

  • 6 December 2020
  • 2 replies
  • 474 views

Forum|alt.badge.img
  • Jr Varsity II
  • 103 replies

Hi 

I would like make some Profit and Loss report (DPL)  figure in Dashboard for easy reference. example: revenue , gross profit , net profit. 

 

Not sure who can share with me how to extract the figure to dashboard?

 

 

Best answer by msw21

Seems like the only way would be to create a generic inquiry that uses formulas that equate to the result you are looking for and base the dashboard off of that.

 

Roll up the accounts by account classes in the inquiry and then use formulas based summary or off the calculated columns.

 

I was able to do something basic by using these two tables. I added a Year Parameter and that gave me current ytd totals.

Hope this helps a little. Maybe someone has a quicker way as I am not completely versed in all the 

tables and fields.

Screen shots below.

Michael

 

 

 

 

Michael

 

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img
  • Jr Varsity II
  • 12 replies
  • Answer
  • December 6, 2020

Seems like the only way would be to create a generic inquiry that uses formulas that equate to the result you are looking for and base the dashboard off of that.

 

Roll up the accounts by account classes in the inquiry and then use formulas based summary or off the calculated columns.

 

I was able to do something basic by using these two tables. I added a Year Parameter and that gave me current ytd totals.

Hope this helps a little. Maybe someone has a quicker way as I am not completely versed in all the 

tables and fields.

Screen shots below.

Michael

 

 

 

 

Michael

 


hi @mws21

 

can i know the condition you use for your parameter?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings