Microsoft Dynamics NAV (Archived)

Get Absolute values on Account Schedules

(0) Share

Report

Posted on by Ruben.Mejia87

166

Hey Lads!

I have a question,

Can I get the absolute value in a column (column layout) for the account schedule?

I mean, if on a previous column I have the value, for example, -1,239.00, Can I have another column that might be the absolute value, this would be 1,239.00.

I know that, in that simple example, I just have to do Column * -1... But, let's say that, in some others rows, I will have positive values, and then, on those other columns, we would have a negative as result.

I want to get as result only absolute values.

Thank you.

*This post is locked for comments

All responses (4)

Answers (1)

Ruben.Mejia87 166 on at

Like (0)

Report

RE: Get Absolute values on Account Schedules

All right!

It worked for my goal!

Thnk you so much :D
Verified answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

RE: Get Absolute values on Account Schedules

There’s no native ABS but you can try this: create a new colunm which is a formula of (A*A)^0.5 , where A is your column.
Ruben.Mejia87 166 on at

Like (0)

Report

RE: Get Absolute values on Account Schedules

Hello,

Thank you for the quick response, but I mean on the functionality 'Account Schedule', so I just need to know if the setup of the column layout on there will allow me to do that.

Again Thank you
Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

RE: Get Absolute values on Account Schedules

In C/AL you have the ABS function that return the absolute value of a number...

[View:https://msdn.microsoft.com/en-us/library/dd355039.aspx]