Estimados, buen día:
Estoy trabajando en la creación de un dashboard, pero el sistema me está arrojando el error mencionado en el título.
¿Podrían ayudarme, por favor?
Gracias de antemano.
Saludos cordiales,
select
d.end_date as "Fecha",
ifnull(
sum(case when l."DocDate" >= d.begin_date and t."ItmsGrpNam" = 'PFE INY' then l."OutQty" else 0 end) * 100 /
nullif(sum((l."InQty" - l."OutQty") * (case when l."DocDate" >= d.begin_date and t."ItmsGrpNam" = 'PFE INY' then 0.5 else 1 end)), 0),
0
) as "Porcentaje (%) de rotación de inventario"
from
OIVL l
right outer join (
select
ADD_YEARS(NEXT_DAY(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -1))), -1) begin_date,
LAST_DAY(ADD_MONTHS(CURRENT_DATE, -1)) end_date
from dummy
union all
select
ADD_YEARS(NEXT_DAY(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -2))), -1) begin_date,
LAST_DAY(ADD_MONTHS(CUR
RENT_DATE, -2)) end_date
from dummy
union all
select
ADD_YEARS(NEXT_DAY(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -3))), -1) begin_date,
LAST_DAY(ADD_MONTHS(CURRENT_DATE, -3)) end_date
from dummy
union all
select
ADD_YEARS(NEXT_DAY(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -4))), -1) begin_date,
LAST_DAY(ADD_MONTHS(CURRENT_DATE, -4)) end_date
from dummy
union all
select
ADD_YEARS(NEXT_DAY(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -5))), -1) begin_date,
LAST_DAY(ADD_MONTHS(CURRENT_DATE, -5)) end_date
from dummy
union all
select
ADD_YEARS(NEXT_DAY(LAST_DAY(ADD_MONTHS(CURRENT_DATE, -6))), -1) begin_date,
LAST_DAY(ADD_MONTHS(CURRENT_DATE, -6)) end_date
from dummy
) d on l."DocDate" <= end_date
left join OITM i on l."ItemCode" = i."ItemCode"
left join OITB t on i."ItmsGrpCod" = t."ItmsGrpCod"
group by
d.end_date;