to compare fields

[#1]

I want to display the agent field for transactions for this year and previous year.

How can I solve this?

[#2]

What is agent field? Please provide some sample data.

Vinay

[manojkulkarni]

Pls could elaborate more on what is the agent field & where do you want to display ?

[#4]

Hi,

Current year  <Year = {"$(=max(Year))"}>

Previous year  <Year = {"$(=max(Year)-1)"}>

[#5]

the agent field contains the agent of that particular transaction and i want to display of this year and of the last year to check whether it changed or not

[#6]

the agent field contains the agent of that particular transaction and i want to display of this year and of the last year to check whether it changed or not

[#7]

the agent field contains the agent of that particular transaction and i want to display of this year and of the last year to check whether it changed or not

[#8]

Hi,

Please see below might be helpful...

Load  * inline
[yr,sale
2010,200
2011,100
2013,50
2014,40
]

;

Current year expression

sum({<yr= {'$(=year(Today()))'}>}sale)

Previous month expression

sum({<yr= {'$(=year(Today())-1)'}>}sale)

Regards

Vinay

[DavidFoster1]

I think we need to understand your data model. From your description above it reads like a transaction last for many years and can have many agents over that time. I suspect that is not the case. Is there a customer/account in the model as well that links the transactions together?

[#10]

i have a table that have transactions throughout the years and each transaction is associated with a particular agent .. so i want to make a table  so that when i choose a particular year a table that contains the client details and the agent of this year and the agent of the previous year for each transaction is displayed.  So that i can identify those records that changed agent