Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
maxwellf
Contributor III
Contributor III

Soma dinâmica

É 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?

Labels (1)
1 Solution

Accepted Solutions
Digvijay_Singh

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

View solution in original post

1 Reply
Digvijay_Singh

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