Discussion Board for collaboration related to QlikView App Development.
I have an expression for rounding durations, with a variable for the rounding step:
vDurationFrac can be 24,48,96 (for 15,30,60 minutes).
When selecting fractions of 30 minutes, it's not clear how the rounding is done.
For example, duration range from 1:45 to 2:14 hours are rounded to 2:00 hours.
There are values 1:44 or 2:15 which are not taken into account.
Can someone clarify please?
I guess I figured it ..
according to Round Help:
"... If x is exactly in the middle of an interval, it is rounded upwards..."
please post some sample data with expected output