4

I have a share point form which has 3 textbox fields (datatype=Numeric) as

  • "Wellbeing leave balance" which is by default 21.
  • Second field is "Remaining balance" which is picks up the leave balance once the leave is applied.
  • 3rd one is "Remaining balance will be" field. I want to use a calculated value which will work like lets say IF "Remaining balance" isblank then populate the value of "Remaining balance will be" field else populate value of "remaining balance".

How can I achieve this? any help would be much appreciated

enter image description here

6

Try this

=IF(ISBLANK([Remaining balance]), [Remaining balance will be], [Remaining balance])

Explanation

It will check if the [Remaining balance] field value is empty, show the value of the [Remaining balance will be] else use [Remaining balance] field value.


Update

I didn't see the InfoPath tag :)

In InfoPath, it's easy to add a Rule Condition as the following:

  • Select your field,
  • Add rule as shown below

enter image description here

  • Select the field as [Remaining balance] and select the value as [Remaining balance will be] from Fx button and insert field.
  • EL-Qassas Im getting error. doesnt allow me – Biswa Nov 30 '18 at 10:56
  • Which error did you get? Are you sure you have added the fields name in a correct manner – Mohamed El-Qassas MVP Nov 30 '18 at 10:57
  • i have added the screenshot of my error on my question. – Biswa Nov 30 '18 at 11:01
  • can you please answer me brother, im watiing – Biswa Nov 30 '18 at 11:18
  • @Biswa Check the updated answer, don't hesitate if you need further clarification! – Mohamed El-Qassas MVP Dec 4 '18 at 9:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.