Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Optimize expression

I have expression: if($(SumQty)>0,$(SumQty),0), but SumQty is very hard expression:

Money(Sum(Aggr($(SumQtyFormula) * $(CostQty)/1000,

  ItemId, DepartmentId, VendId)),'# ##0,00').

When I write if($(SumQty)>0,$(SumQty),0) - QV calc $(SumQty) twice? How I can change expression that calc once?

1 Solution

Accepted Solutions
Not applicable
Author

try:

rangemax($(SumQty),0)

regards

Darek

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

I think it is not possible!

Not applicable
Author

try:

rangemax($(SumQty),0)

regards

Darek

Not applicable
Author

Thank you so much!