Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody. I would appreciate some help with this:
I'm trying to get the value of field price in everyrow but from a specific value of field Trade. For example what i'm expecting is column compareprice of the next table. Where compareprice is the value of price where Trade = 'WM_GT'
The next step is i can choose dynamically the Trade i want compare to every row for anyone combination of Country, Family, description and seller.
Thanks in advance.
try this expression: = sum(total <Description> {<Trade={'WM_GT'}>}Price)
try this expression: = sum(total <Description> {<Trade={'WM_GT'}>}Price)
will the comparison always be WM_GT? wouldnt the user want to select it? if so create a variable that holds the selected trade (assuming user can only choose 1) with expression =only(Trade)
then in the price expression: sum({<Trade=>}Price)
and your compare expression: sum(total <Description> {<Trade={'$(YourVariable)'}>}Price)
It Works. Thank you!
Yeah. I'll have it in mind. Thanks.