Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to everyone!
I have a table with column:
Previous month sales. Expression:
Sum({$< DateSale=, MonthSale=, YearSale=, DateSale = {'>=$(=vStartPrevPeriod_month) <$(=vMinSelectedDate)'},
Field1={'2937.3'}, Field2={"=WildMatch(Field2,'841*','831*','811*','3350')"} >} SUM)/1000
I select YearSale=2015
MonthSale=September
vStartPrevPeriod_month=01.08.2015
vMinSelectedDate=01.09.2015
So, I analyze sales in August month of 2015.
Problem: Expression does not take values of Field1=2937.3 and Field2=8113,8114 in period of august 2015. They exist in my qvd.
But with other values it works good.
Please help. How to solve it. May be there is another funtion like WildMatch.. I also tried 'LIKE' function. The result is the same.
Hi,
try this
Sum({$< DateSale=, MonthSale=, YearSale=, DateSale = {'>=$(=vStartPrevPeriod_month) <$(=vMinSelectedDate)'},
Field1={'2937.3'}, Field2={'841*','831*','811*','3350'} >} SUM)/1000
Regards
Hi,
try this
Sum({$< DateSale=, MonthSale=, YearSale=, DateSale = {'>=$(=vStartPrevPeriod_month) <$(=vMinSelectedDate)'},
Field1={'2937.3'}, Field2={'841*','831*','811*','3350'} >} SUM)/1000
Regards
Hi Iskander,
apply NUM# function for Field1 and Field2. This might works!
HTH,
Sreeni
Thank you very much! It works.
I made it so complicated)..