Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
How can I get this expression "LOTES" on the script:
count(distinct(aggr(Nro.Lote,Nro.Mat,Nro.Lote,Período)))
So then I cant get this Expression on the script too:
if ([Lotes]<=7,([Lotes]/1)*([AhorroHsComp]), if ([Lotes]>7 ,([Lotes]/4)*(AhorroHsComp)))
LOAD
count(distinct Nro.Lote)
from yourqvd
group by Nro.Mat,Nro.Lote,Período;
LOAD
if ([Lotes]<=7,([Lotes]/1)*([AhorroHsComp]), if ([Lotes]>7 ,([Lotes]/4)*(AhorroHsComp))) as newfield
from yourqvd;
Clever... does not work your soolution.
its returns '1'
I got this in a graph:
The column Lotes is:
count(distinct(aggr(Nro.Lote,Nro.Mat,Nro.Lote,Período)))
I need to have this values already on the script!
Please upload sample data.
try this,
aggr(count(distinct(Nro.Lote,Nro.Mat,Nro.Lote,Período)))