How to get this expression on Script??

[#1]

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)))

[Clever_Anjos]

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;

[#3]

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!

[rbecher]

Please upload sample data.

[#5]

try this,

aggr(count(distinct(Nro.Lote,Nro.Mat,Nro.Lote,Período)))