Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
When i take this expression into a text object i dont see any values in it , and this is what i see as shown in the image . is the expreesion wrong ? or do i need to make some changes to this ?
Aggr(
Num(
Rank(
If(Sum(
{
<
Date= {">=$(StartDate)<=$(EndDate)"},
Department = P(Department_S)
>
} Count
)>0,
Sum(
{
<
Date= {">=$(StartDate)<=$(EndDate)"},
Department = P(Department_S)
>
} Count
), null()),
4
),
'#.##0'
),
Cust_Code
)
There is a variable within which we have below mentioned expression, is there any way to include within the this a expression which will neglect the selection made out side for the field 'BASE'
and the field BASE has two value in it 'A' and 'B' ......and by default using some triger they have set the BASE to 'A'
and i want to exclude the BASE selection in the bove expression.
Thanks in advance
Hi,
try below
Aggr(
Num(
Rank(
If(Sum(
{
<
Date= {">=$(StartDate)<=$(EndDate)"},
Department = P(Department_S),
BASE=
>
} Count
)>0,
Sum(
{
<
Date= {">=$(StartDate)<=$(EndDate)"},
Department = P(Department_S),
BASE=
>
} Count
), null()),
4
),
'#.##0'
),
Cust_Code
)
Regards,
Hi Prashant
I tried this also but its not working
. is there any way to deselect BASE within this expression ?
Hi,
what do you mean not working???
If possible,can you post sample file
Regards,
There is an external trigger being set by which always 'A' values is being selected in thtr BASE field.
and i have to manaulyy deselect ' A' to get the values ... therefore i wanted an expression which will deselct the 'A' within BASE and give the out put..
Below is the attachment screen which is selected bydefualt ....
and when i manaully deselect A then there will be out put for me for the above expression , and it will be like this after delsecting
Hi,
when you nullify any fields it will give result which will not consider your selection.
try this in text object
Sum(
{
<
Date= {">=$(StartDate)<=$(EndDate)"},
Department = P(Department_S),
BASE=
>
} Count
)
Regards,
Prashant
This works Prashanth,
When i take ur expression into text object it works but when i take my expression into a text object it gives me - values, attached in the screen shot .
is Aggr expression itslef wrong ?