Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Unable to Calculate the value of amount

(0) ShareShare
ReportReport
Posted on by 261

Hi everyone,

I had faced one problem which is to calculate the amount (formula:direct unit cost * quantity).

I had try to put above formula into the layout (Format textbox), but after run it, the amount still is zero. (Refer to picture)

So may I know where I can put the formula in order to generate the amount?

0564.Capture6.PNG

0564.Capture5.PNG

Thanks.

*This post is locked for comments

  • Jade Ng Profile Picture
    261 on at
    RE: Unable to Calculate the value of amount

    Hi all,

    I had settled my problem already.

    Thanks.

  • Jade Ng Profile Picture
    261 on at
    RE: Unable to Calculate the value of amount

    Hi,

    Thanks for reply.

    I have check again the expression, I no used wrong field name ( the picture above is the header actually).

    And one more thing i have to say that, in my return shipment line actually does not have the field of amount, but now i have create the field of amount into the table of return shipment line, then i pull out and put into the report layout.

    But then it does not work, the amount still remain zero (actually the value of amount is direct unit cost * quantity).

    And when I create the formula direct unit cost * quantity in the page of return shipment lines, the value of amount able to work, but when generate the report, it still remains zero.

    Anything i forget to insert?

    So, can anyone give me some suggestions?

    Thanks.

  • Suggested answer
    I Gusti Made Ari Profile Picture
    3,594 on at
    RE: Unable to Calculate the value of amount

    Looks like you are using wrong  field name for the formula ,  Check the expression of Quantity and Direct Unit Cost  column which field name  it is using

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans