Help with if logic expression

[DPM_reports]

Hi,

I have a column which calculates duration,

In another column I need to put if expression where if duration more than 4 hrs, I need it to return 1 else 0.5

Pls help @Aleksi @Suvrutt_Gurjar

[hru]

This?

IF(TOTALHOURS([DurationColumn])>4, 1, 0.5)

[DPM_reports]

Not working…when duration is less than 4 hrs I am getting 1 instead of 0.5…which is not correct

[hru]

DPM_reports:

if duration more than 4 hrs, I need it to return 1

The suggested expression does that.

DPM_reports:

when duration is less than 4 hrs I am getting 1

Should not.

You might need to share the screen shoot.

[DPM_reports]

If u see here the Duty time column is less than 4 hrs in total …hence I must get 0.5 in the count column…instead I am getting 1

[hru]

Hmmm to be sure, could you place your mouse on the number “1” and check if you click this:

[DPM_reports]

It’s showing 1.0

[hru]

Please provide the snapshot of the expression, and also screen shoot of the detail view of that row from the emulator editor.

[DPM_reports]

I don’t mind using a expression in google sheet instead on Appsheet

[hru]

The [Count] column is not appearing in the detail view, I suggest you edit the record in a form and save it to the sheet. Let see if the record showing correctly (though in my opinion, you will need an action for this kind of requirement). However, first, lets edit the record in the form and save it (include the column in the slice also).

[DPM_reports]

Still showing 1 instead of 0.5

[hru · Accepted solution]

Ah… You need to change the column type of the “Count” column. it should be decimal column type with decimal digit of 2.

[DPM_reports]

At last …Breakthrough…Thanks @Heru

Getting right results now