Answered

DV Calculated column and IF statement

(0) Share

Report

Posted on by ckserra33

421

Hi everyone. I am new to Dataverse and I am using a calculated column to show the remaining value left on an item. This is working correctly, and the code I am using is below:

cr3db_totalcost - (cr3db_monthlydepriciationamount * cr3db_monthsfromacquire)

The issue is the numbers will eventually go negative. I need it to stop at 0. I was trying to use an IF statement, but cannot figure out the correct syntax.

Something like If(NBV column >0,cr3db_totalcost - (cr3db_monthlydepriciationamount * cr3db_monthsfromacquire),0)

But I am 100% positive I am not approaching it correctly.

Thank you for any help!

Chris

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

João Santos 323 on at

Like (1)

Report
Copy link

Link copied!

Hi,
I feel like this is possible, but you might need to do two calculated fields instead of one. Something like
Calculated Field 1: Total Depreciation = cr3db_monthlydepriciationamount * cr3db_monthsfromacquire
No condition for this one
Then:

Calculated Field 2: Current Value
If (Total Amount < Total Depreciation)
Current Value = 0
Else
Current Value = Total Amount - Total Depreciation

Hope this helps

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @ckserra33 ,

Note (IN PREVIEW) but Power Fx in Dataverse should be able to easily handle your situation here with the advanced formulas that can be used... Example article explaining the functionality: https://powerapps.microsoft.com/en-us/blog/power-fx-formula-columns-in-dataverse/

The logic you are looking to do here would be basic with Power Fx (in preview) in Dataverse...

Was this reply helpful? Yes No
ckserra33 421 on at

Like (0)

Report
Copy link

Link copied!

@joaodsantos Thank you very much. I figured it was something like that, thanks again!

Was this reply helpful? Yes No
ckserra33 421 on at

Like (0)

Report
Copy link

Link copied!

@pdp Thank you very much for the idea, I just felt more comfortable doing it with 2 columns at this point in my knowledge of DV. Thank you very much!

Was this reply helpful? Yes No