Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
May be anyone know why i can't use such thing:
Aggr(sum(Quantity_i),AffiliateID, bg_t, Id,left(date_a,6))
exp. i have date_a:
20120101
20120102
20120201
20120305
and i need use Aggr with only month not full date
i try use left(date_a,6) but it is not working
Hi yes you can not get the month this way.
-First of all tell the date format'dd/mm/yy' or what??
try this----
=right(left(Date#(last_accessed),6),2)
Lets see
hi, sujeetsingh!
field "date_a" in my table is in format - varchar(15)
Hai
pls use conditional dimension for that date_a field
there u need put
left(date(date_a,6))
sorry pls use right(field name ,2)
Hi,
At script level you may create a field, Left(date_a,6) as month.
Then within expression you may use Aggr(sum(Quantity_i),AffiliateID, bg_t, Id, month)
Regards,
Som
Hai
You mean create new field when i load data with condition?
it is works thank you
is it not alowed any functions such as left(field,n) inside Aggr function because of Syntaxis?
and any time i have to add new fields with conditions?
As per my knowledge, Aggr function takes only dimensions not calculated dimesions.
Regards,
Som
thank you !