Calculations of field with different format

[dwivedi_shashan]

Hi,

I am new to qlikview and not able to get the correct result due to different formats of field when dividing Actual/Expected.

Below is field definition:

interval(Interval((End_Time-Start_Time),'ss')/5,'ss') as 'Expected'

COUNT(DISTINCT(updated)) as 'Actual'

For ex: My Expected is 516 and actual is 29 but actual/expected is coming 4855.8139534884.

Please help.

[dwivedi_shashan]

Hi,

Is there someone who have faced same issue and help on this

[Frank_Hartmann · Accepted solution]

num#(interval(Interval((End_Time-Start_Time),'ss')/5,'ss')) as 'Expected'