Percentage and Sub Total Calculations

Question

Hi,I need to create a calculation so that whatever is entered into the 'percentage uplift' box gets added to the 'subtotal own stock' and gives me a total. Do I need a javascript to do this? Should I keep the percentage uplift field a percentage or a number? Hope you can help Thanks

ls_rbls · Accepted Answer

++Adding to the discussion,

I see that you have all the text field object names starting with a number.

I've read in other threads in this community that when you use simplified notation or the built-in "SUM" feature to calculate field values it may throw errors.

What I would do in this caseis to follow the same guidance that George Johnson already gave you but change the field names. In particular just eliminate the "5" that is preceding every field name in your PDF and see if that resolves the issue.

George_Johnson · Answer

You don't need to use JavaScript necessarily, unless you have specific rounding requirements. You could use the simplified field notation option when setting up a calculated field, and it would probably be best to set it to a number and configure the calculation correctly. For example, in the Totals field, the what you'd enter could be:

5OwnStockSubTotal * (1 + 5PercentageUplift / 100)

Assuming that's the correct formula.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded