how to calculate the field in script level....?

[#1]

Hi All,

I am using the below expression in script level.But its not working what is the problem

I am calculating the Max month related data is store into current2015count field.

if(Created_date = date(max(Created_date),'MMM') ,[2015  Count 1],) as current2015count

[timanshu]

Hi Subbu,

As per Question, you are doing this by load statement.

If this is case, then you can't use aggregate functions in load statement without using group by clause.

But In your case using group by clause is not logical and will not either solve your problem.

So you first need to take a variable above this load statement and assign it  value as max(Created_date) :

Let vMaxDate = max(Created_date).

Then in load statement write the variable instead of max(Created_date). like :

if(Created_date = date('$(vMaxDate)','MMM') ,[2015  Count 1],) as current2015count

This will solve your concern.

[jagan]

Hi,

You need to use Group by if you are using Max() in Load script, attach some sample data and let us know your required output.

Regards,

Jagan.

[jonathandienst]

Hi

I suggest you attach the load script for the table that contains the line in question.Sample data and a complete load script would also help.

Jonathan

[avinashelite]

can you please attach the app with sample data??

[#6]

Hi,

this is my sample data.

Name	subject	Date	value Count	marks
mike	English	31-Jan-15	0	20
mike	maths	31-Jan-15	0	21
mike	science	31-Jan-15	0	24
mike	social	31-Jan-15	0	25
hari	English	31-Jan-15	2	22
hari	maths	31-Jan-15	2	24
hari	science	31-Jan-15	2	26
hari	social	31-Jan-15	2	27
john	English	31-Jan-15	4	18
john	maths	31-Jan-15	4	20
john	science	31-Jan-15	4	29
john	social	31-Jan-15	4	30
sai	English	31-Jan-15	1	20
sai	maths	31-Jan-15	1	22
sai	science	31-Jan-15	1	24
sai	social	31-Jan-15	1	26
mike	English	28-Feb-15	0	20
mike	maths	28-Feb-15	0	21
mike	science	28-Feb-15	0	24
mike	social	28-Feb-15	0	25
hari	English	28-Feb-15	2	22
hari	maths	28-Feb-15	2	24
hari	science	28-Feb-15	2	26
hari	social	28-Feb-15	2	27
john	English	28-Feb-15	4	18
john	maths	28-Feb-15	4	20
john	science	28-Feb-15	4	29
john	social	28-Feb-15	4	30
sai	English	28-Feb-15	1	20
sai	maths	28-Feb-15	1	22
sai	science	28-Feb-15	1	24
sai	social	28-Feb-15	1	26

and my expected design is:

Name	Baseline Valuecount	Current value count	Subject	Baseline Marks	Current Marks
mike	0	0	English	20	20
			maths	21	21
			science	24	24
			social	25	25
hari	2	2	English	22	22
			maths	24	24
			science	26	26
			social	27	27
john	4	4	English	18	18
			maths	20	20
			science	29	29
			social	30	30
sai	1	1	English	20	20
			maths	22	22
			science	24	24
			social	26	26

Plz help me in this part.

plz write the discussion in discussion window only.

[#7]

Hi,

this is my sample data.

Name	subject	Date	value Count	marks
mike	English	31-Jan-15	0	20
mike	maths	31-Jan-15	0	21
mike	science	31-Jan-15	0	24
mike	social	31-Jan-15	0	25
hari	English	31-Jan-15	2	22
hari	maths	31-Jan-15	2	24
hari	science	31-Jan-15	2	26
hari	social	31-Jan-15	2	27
john	English	31-Jan-15	4	18
john	maths	31-Jan-15	4	20
john	science	31-Jan-15	4	29
john	social	31-Jan-15	4	30
sai	English	31-Jan-15	1	20
sai	maths	31-Jan-15	1	22
sai	science	31-Jan-15	1	24
sai	social	31-Jan-15	1	26
mike	English	28-Feb-15	0	20
mike	maths	28-Feb-15	0	21
mike	science	28-Feb-15	0	24
mike	social	28-Feb-15	0	25
hari	English	28-Feb-15	2	22
hari	maths	28-Feb-15	2	24
hari	science	28-Feb-15	2	26
hari	social	28-Feb-15	2	27
john	English	28-Feb-15	4	18
john	maths	28-Feb-15	4	20
john	science	28-Feb-15	4	29
john	social	28-Feb-15	4	30
sai	English	28-Feb-15	1	20
sai	maths	28-Feb-15	1	22
sai	science	28-Feb-15	1	24
sai	social	28-Feb-15	1	26

and my expected design is:

Name	Baseline Valuecount	Current value count	Subject	Baseline Marks	Current Marks
mike	0	0	English	20	20
			maths	21	21
			science	24	24
			social	25	25
hari	2	2	English	22	22
			maths	24	24
			science	26	26
			social	27	27
john	4	4	English	18	18
			maths	20	20
			science	29	29
			social	30	30
sai	1	1	English	20	20
			maths	22	22
			science	24	24
			social	26	26

Plz help me in this part.

plz write the discussion in discussion window only.

[#8]

Hi,

this is my sample data.

Name	subject	Date	value Count	marks
mike	English	31-Jan-15	0	20
mike	maths	31-Jan-15	0	21
mike	science	31-Jan-15	0	24
mike	social	31-Jan-15	0	25
hari	English	31-Jan-15	2	22
hari	maths	31-Jan-15	2	24
hari	science	31-Jan-15	2	26
hari	social	31-Jan-15	2	27
john	English	31-Jan-15	4	18
john	maths	31-Jan-15	4	20
john	science	31-Jan-15	4	29
john	social	31-Jan-15	4	30
sai	English	31-Jan-15	1	20
sai	maths	31-Jan-15	1	22
sai	science	31-Jan-15	1	24
sai	social	31-Jan-15	1	26
mike	English	28-Feb-15	0	20
mike	maths	28-Feb-15	0	21
mike	science	28-Feb-15	0	24
mike	social	28-Feb-15	0	25
hari	English	28-Feb-15	2	22
hari	maths	28-Feb-15	2	24
hari	science	28-Feb-15	2	26
hari	social	28-Feb-15	2	27
john	English	28-Feb-15	4	18
john	maths	28-Feb-15	4	20
john	science	28-Feb-15	4	29
john	social	28-Feb-15	4	30
sai	English	28-Feb-15	1	20
sai	maths	28-Feb-15	1	22
sai	science	28-Feb-15	1	24
sai	social	28-Feb-15	1	26

and my expected design is:

Name	Baseline Valuecount	Current value count	Subject	Baseline Marks	Current Marks
mike	0	0	English	20	20
			maths	21	21
			science	24	24
			social	25	25
hari	2	2	English	22	22
			maths	24	24
			science	26	26
			social	27	27
john	4	4	English	18	18
			maths	20	20
			science	29	29
			social	30	30
sai	1	1	English	20	20
			maths	22	22
			science	24	24
			social	26	26

Plz help me in this part.

plz write the discussion in discussion window only.

currentcount means current month data baselinecount means jan month data it is fixed one

[#9]

currentcount means current month data baselinecount means jan month data it is fixed one.

[#10]

currentcount means current month data baselinecount means jan month data it is fixed one