How to make a report calculate value from total

anton1987
anton1987 Member Posts: 35
edited 2009-08-11 in NAV/Navision Classic Client
Hi guy. as you all know Im still Pretty new at Nav.

I have some slight issues that I thought you could help me with.

I have a report basedon report 1001 - Inventory Valuation.

I am using it for a mill and they want to calculate there Grist %.

But for me to calc there Grist Percentage I need to take the negative Adjusments and divide it by the total of the negative adjustments

But I have no Idea how.


Please help !!!!!!!!!1 ](*,)

Comments

  • ara3n
    ara3n Member Posts: 9,258
    What is your skillset?

    I think you need a developer to look at the report.

    you need to create a variable called totalNegAdjment of type Decimal

    Basically as it loops through item ledger entry you need to create

    you are going to check the entry type and if it's negative adj, you are going to add to totalNegAdjment.

    But for me to calc there Grist Percentage I need to take the negative Adjusments and divide it by the total of the negative adjustments

    The above quote doesn't make sense to me.
    Are you printing the detail to see each entry and then print the Grist % for each negative adjustment?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • ara3n
    ara3n Member Posts: 9,258
    If you know sql reports, you can use the following sql report and make the necessary modification.



    http://mibuso.com/blogs/ara3n/2009/07/0 ... amics-nav/
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • anton1987
    anton1987 Member Posts: 35
    Hi

    Thaks for the help. I figuered it out.
    I had to create a function to loop through the table and calculate negative adjmt before the report runs so that the value can be used in the report at later stage.

    Thanks for the help though

Categories