How to make a report calculate value from total

anton1987

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 ](*,)

ara3n

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?

ara3n

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/

anton1987

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