calculate a value

(0) Share

Report

Posted on by russelln1

202

Hi

I have a powerapp which I'm creating a leavers form

Using SharePoint I have 3 columns; HolEnt, HolTaken and HolBal. From the HolEnt and HolTaken I need it to populate the difference in the HolBal column.

I have made HolBal a calculated column and used =[HolEnt]-[HolTaken] in the formula area but it's not returning the value.

HolEnt and HolTaken are Choice columns

How do I go about getting the HolBal to return the difference of HolEnt minus HolTaken in powerapps?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

SBax 1,348 on at

Like (1)

Report
Copy link

Link copied!

Hi @russelln1

I believe you need to convert the choice values to int() before calculation

just testing this now

Was this reply helpful? Yes No
SBax 1,348 on at

Like (1)

Report
Copy link

Link copied!
@russelln1- if you use this formula this should calculate it

If you convert to text then to int, you should be able to achieve this

I have used a gallery for the purpose of getting the people, holEnt and HolTaken

the formula I used to calculate holBal was:

Int(Text(ThisItem.HolEnt))-Int(Text(ThisItem.HolTaken))

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @russelln1 ,

Please try this formula in your SP list:

=VALUE([HolEnt])-VALUE([HolTaken])

Best Regards,

Bof

Was this reply helpful? Yes No
russelln1 202 on at

Like (0)

Report
Copy link

Link copied!

@v-bofeng-msft @SBax

Thank you both for your comments - I will try both out tomorrow.

Was this reply helpful? Yes No