Result

[deepakqlikview_123]

Hello all,

Please find attachment.

Below is a formula that I have used while calculating % absent employee.

=num(

  (sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

  -

  sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

/

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),'#,#0%' )

Now as per requirement if absent employee =100% then there is need to show Null or some image

Can u please suggest how to proceed.

Thanks,

[its_anandrjs]

Try like

= If( (num(

  (sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

  -

  sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

/

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),'#,#0%' ) ) ='100%' ,Null(),

(num(

  (sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

  -

  sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

/

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),'#,#0%' ) ))

[its_anandrjs]

Or you can write

= If( (num(

  (sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

  -

  sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

/

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),'#,#0%' ) ) ='100%' ,'qmem://<bundled>/BuiltIn/smiley1_g.png',

(num(

  (sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

  -

  sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

/

sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),'#,#0%' ) ))

[deepakqlikview_123]

Hi anand,

Smiles are not working here.

Thanks

[its_anandrjs · Accepted solution]

After adding above expression change your expression as image and image formatting keep Aspect.

See the attached snap

[deepakqlikview_123]

Thanks anand,

It worked.