calculate a value

Like (0) Share

Report

Posted on 31 Aug 2022 10:10:57 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:

Connecting to Data

General Questions

All responses (4)

Answers (1)

russelln1 202 on 01 Sep 2022 at 13:44:47

Like (0)

Report

Re: calculate a value

@v-bofeng-msft @SBax

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

v-bofeng-msft on 01 Sep 2022 at 06:32:25

Like (1)

Report

Re: calculate a value

Hi @russelln1 ,

Please try this formula in your SP list:

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

Best Regards,

Bof
SBax 1,348 on 31 Aug 2022 at 17:32:36

Like (1)

Report
Re: calculate a value

@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))
SBax 1,348 on 31 Aug 2022 at 17:20:07

Like (1)

Report

Re: calculate a value

Hi @russelln1

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

just testing this now