Formula

[deepakqlikview_123]

Hello Team,

want to show percentage for difference between Man on role and presnent as per DeptFlag FAB

For that pupose I am using below formula.But it seems it is not working.

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

-

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

/

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

Can you please suggest what corrections are required in this.

Thanks,

Deepak

[MK_QSL · Accepted solution]

Try this...

=num(

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

  -

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

/

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

[its_anandrjs]

Write like below

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

               -

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

               /

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

Use brackets for the Numerator or denomenator sepearate

and let me know

[deepakqlikview_123]

Hi Anand/Manish,

It is working fine now.

Can you please tell me while formatting what kind of parameters we need to consider.

Thanks