Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i need to filter my Count() only when a condition is verified, in details:
i need to Count, only items where my field ANNO_EMI = ANNO + 1
Hi Daniele,
may be like this:
Count (Distinct {<ANNO_EMI ={'ANNO + 1'}>} PDR)
Thanks,
Arvind Patil
I think there are an error becouse if i write like this it not show me nothing but if i write:
Count (Distinct {<ANNO_EMI ={'04'}>} PDR)
it show me the line..... i think the error is in the field ANNO + 1
May be this
Count(DISTINCT {<ANNO_EMI = {"$(=Num(ANNO+1, '00'))"}>} PDR)
No, i think problem is in the Field ANNO, the formula not take it, becouse is i write :
Count(DISTINCT {<MESE_EMISSIONE = {"$(=Num(2+1, '00'))"}>} PDR)
it take me the value and design the line in the chart
May be there are multiple values and you need to use Max() or Min() function
Count(DISTINCT {<ANNO_EMI = {"$(=Num(Max(ANNO)+1, '00'))"}>} PDR)
Look at the picture, it not show me nothing..... my field MESE_EMISSIONE is in my database with value format 01... 12 and MESE_COMPETENZA with the same format.... if i use that kind of formula with replace MESE_COMPETENZA with a number value, chart show me values
Count(DISTINCT {<MESE_EMISSIONE = {"$(=Num(2+1, '00'))"}>} PDR)
What do you get when you add this to a text box object?
=Num(Max(ANNO)+1, '00')
Do you get 03?
I get all these values, like you see in the line chart
I was asking for this expression in a text box object, not a line chart?