How to show calculated field in UI level

[madhubabum]

Hi all

Here I am attaching the Sample Application:

Problem : If i am using the calculation in Script level "Getting Some Profit Center's " Information only in UI level.

               But , If i'm using the same calculation in UI level "Getting All Profit Centers" Information.

I want to Use calculation in Script level & I want to show  " All Profit Center's information in UI level".

How we can Achieve this one ?

[vardhancse]

Was not clear,

are you trying to see the data for the calculated filed created in script level.?

[madhubabum]

Hi Sasi v Kandragula

Thanks for your reply

I want to show in UI level

[madhubabum]

Avg(if(%ORDER_DATE_KEY >$(vEndDate),WorkOrderLaborHours)) as Last_12_Months_Avg_Labour_Hours

[madhubabum]

Avg(if(%ORDER_DATE_KEY >$(vEndDate),WorkOrderLaborHours)) as Last_12_Months_Avg_Labour_Hours

[jagan]

Hi,

Try like this

Avg(if([%ORDER_DATE_KEY] >'$(vEndDate)',WorkOrderLaborHours)) as Last_12_Months_Avg_Labour_Hours

Regards,

Jagan.