Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to Everyone.
I have a chart with these fields:
Dimenssions:
-date
-invoice number
Expression:
QUANT (the expression is : sum({$<YEAR-={$(YEAR)}>} PPC_IVQUANT)
I have two field for selection YEARS and MONTHS.
What I want to do, is to exclude from this tabe lines where the date falls on the selected dates range ( The test here is for the year only, but it didnt work out).
I couldnt it solve it after many times. Please consider that the user can selected some months together.
I can't use "1-$ " becuse I want the results to regard the selected product in a nother field/
I will appriciate any help/
Thnak you,
Osher Sassoni.
Hi,
Try something like this
sum({$<YEAR=E(YEAR)>} PPC_IVQUANT)
Regards
ASHFAQ
Thank you for your reply.
I still have problem with the dimenssion - DATE . How do I exclude from it dates which fall in the selected range ??
Now it still shows all dates without any restriction.
Hi,
You can add DATE dimension too.
sum({$<YEAR=E(YEAR),DATE=E(DATE)>} PPC_IVQUANT)
hope it helps
Regards
ASHFAQ
Thank you but it still doesn't work.
I have a chart table with these fields: Date(dimenssion), Invoice_num(dimenssion),line(dimenssion) , Quant(expression).
The table shows invoice's lines.
What I want to do is to show in the table only lines which don't fall in the selected range of dates.
mean to say that if I have for example :
01/01/12 1234 1 40
01/01/11 5678 1 50
05/04/11 8098 3 40
and I have selected Year = 2011 and Months = feb and Apr , I will see in table only lines 1 and 2.
I used your expression for the Quant field, but I still get all lines. I think i should use kind of calculated dimenssion, for my date field but can't figure which expression I should use. I tried yours but it stil dont work.
Like this
Regards
ASHFAQ