How to get value from parameter base on condition ?

[danipudianto]

Dear All,

How to get Value PLANNED_DT / JAM KERJA in MIN Column ?

I have try make query : sum({<DOWNTIME={'PLANNED_DT'}>MINUTES ) / sum({<DOWNTIME={'JAM KERJA'}>MINUTES)

but the result in PLANNED_DT % = 0

Please get me Solution

Thanks

[Anil_Babu_Samineni]

Expression wrong in your thread, try this

sum({<DOWNTIME={'PLANNED_DT'}>} MINUTES)/ sum({<DOWNTIME={'JAM KERJA'}>}MINUTES)

[Kushal_Chawda]

At first glance, looks like a syntax error

sum({<DOWNTIME={'PLANNED_DT'}>} MINUTES ) / sum({<DOWNTIME={'JAM KERJA'}>}MINUTES)

[danipudianto]

Sorry,

but no difference between your query and me.

and the result still zero

Thanks

[Anil_Babu_Samineni]

Two to split

sum({<DOWNTIME={'PLANNED_DT'}>} MINUTES)

[danipudianto]

Hi Anil,

Sorry I am still confuse,

I want the value in PLANNED_DT % = PLANNED_DT / JAM KERJA

and my script is

=if(DOWNTIME='PLANNED DT %',sum({<DOWNTIME={'PLANNED_DT'}>} MINUTES) / sum({<DOWNTIME={'JAM KERJA'},DOWNTIME>}MINUTES),

sum(MINUTES))

but the result in PLANNED_DT % = 0

It's wrong in my script ?

Thanks

[Anil_Babu_Samineni]

Are you trying this in Script? Try same expression in UI