Hi all,

I’m trying to get a bar chart to display amounts in £GBP using the format 'L999G999G999G990D0'. However, the BASE_UNIT_PRICE is still appearing as US dollars, and it won’t populate on the axis in IFS.

Can anyone recommend how to fix this issue?

Here’s my query and column setup:

Query:

WHERE

planned_delivery_date BETWEEN NVL(TO_DATE('$Start Date$', 'MM-DD-YYYY'), TRUNC(SYSDATE, 'YYYY'))

AND NVL(TO_DATE('$End Date$', 'DD-MM-YYYY'), SYSDATE)

AND objstate != 'Cancelled'

AND contract LIKE NVL(UPPER('$SITE$'),'%')

AND company LIKE NVL(UPPER('$COMPANY$'),'%')

AND customer_no LIKE NVL(UPPER('$CUSTOMER_NO$'),'%')

AND &AO.Customer_Order_API.Get_Authorize_Code(order_no) LIKE NVL(UPPER('$COORDINATOR$'),'%')

ORDER BY

to_char(planned_delivery_date, 'MM'), to_char(planned_delivery_date, 'Mon'), to_char(planned_delivery_date, 'YYYY')

GROUP BY

to_char(planned_delivery_date, 'MM'), to_char(planned_delivery_date, 'Mon'), to_char(planned_delivery_date, 'YYYY')

Columns:

• Order Lines: COUNT(order_no)

• Orders: COUNT(DISTINCT(order_no))

• Total Net Amount:

TO_CHAR(SUM(ROUND(BASE_UNIT_PRICE_INCL_TAX)), 'L999G999G999G990D0')

• Month:

TO_CHAR(planned_delivery_date, 'MM') || ' - ' || TO_CHAR(planned_delivery_date, 'Mon') || ' - ' || TO_CHAR(planned_delivery_date, 'YYYY')

Any advice would be greatly appreciated!

Thanks in advance,

Anthony