Rounded up in table

[Lucky1]

Hi I have values like 374.4 i want to round this upto 375.

whatever value after 374.01 round to next value.

if i have 3.02 it should show 4

how to do this my dimension expression is 

if( STATUS = 'PROPOSED_POLICY_NON_COMPLIANT', '* Reda *', DAYSOVERDUE)

[Mark_Little · Accepted solution]

The function you are going to need is the Ceil.

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Ge...

This would need to wrap in the relevant if to meet your condition to round up.

Something like

IF(Subfield(Value,'.',2) = 01 then, Value, CEIL(Value)) AS Value.

Value being you Field name with the number in.

[Lucky1 · Accepted solution]

I found solution by using below logic for roundup

if( STATUS = 'PROPOSED_POLICY_NON_COMPLIANT', '* Reda *', Ceil(DAYSOVERDUE))