Answered

Round down calculation column

(1) Share

Report

Posted on by Memtiger

In my Dataverse table I have a column that multiplies 2 columns together which works but I have been asked to make it round down the calculation in model driven app. When I edit I can't seem to find a way to add that to my calculation. Has any done that?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Shashank Bhide 942 Moderator on at

Like (0)

Report

Can you create a formula column as below

Was this reply helpful? Yes No
Memtiger 46 on at

Like (1)

Report

Thank you that works as I hoped. I had some other fields that were currency, so I had to add the decimal property to the equation. So for me it looked something like this formula.

RoundDown(Decimal('Currency field')*('Number2'),0)

Was this reply helpful? Yes No