Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
É possível fazer um tipo de "soma dinâmica". Ex:
count({<$(vParetoFatBrut)= {'AC'}>} cliente_abc )
Onde
$(vParetoFatBrut)
=
RangeSum(Above(
(Sum([vl-merc-liq]+[vl-icmsub-it]+[vl-ipi-it])+Sum([vl-frete]+[vl-seguro]+[vl-embalagem]))
/
(Sum(total([vl-merc-liq]+[vl-icmsub-it]+[vl-ipi-it]))+Sum(total([vl-frete]+[vl-seguro]+[vl-embalagem])))
,0,RowNo()))
Existe alguma forma?
Thats confusing! Your left side is appearing numeric and right side is text, not sure what exactly you are trying, check if this kinda set expression can be applied -
sum( {$ <MANUFACTURER_LDESC={"=sum([Value Sales])>100000"} >} [Volume Sales])
Thats confusing! Your left side is appearing numeric and right side is text, not sure what exactly you are trying, check if this kinda set expression can be applied -
sum( {$ <MANUFACTURER_LDESC={"=sum([Value Sales])>100000"} >} [Volume Sales])