Need help in set analysis

[#1]

Hello Friends,

I have used the following expression to find the last year sales with the mode of transport is 'Road'

=If([Type]='Road',Sum({$<ShipmentYear={$(=Year(Today())-1)}>} Sales)),

2. and also the TYPE may be dynamic based on selection it has to show the last year sales.

Regards

Chriss

[#2]

Hi Chris,

Whats The Output You Have?

Try This =If([Type]=Road,Sum({$<ShipmentYear={$(=ShipmentYear(Today())-1)}>} Sales))

Can You Please Share Your test app with me.

Thanks & Regards,

Nirmal.

[#3]

Hello Nirmal,

There is no output is coming for the expression but there is no error is showing on the expression.

I don't know where I am making a mistake, could you please tell me how to proceed further.

Reards

Chriss

[#4]

Are You use the Below expression.

=If([Type]=Road,Sum({$<ShipmentYear={$(=ShipmentYear(Today())-1)}>} Sales))

[#5]

Hello Nirmal,

The same is used by me, there is no result...

Regards

Chriss

[#6]

Hi

create one variable for last year like

vyear=year(today())-1

sum({<type={'road'},ShipmentYear={">=$(vyear)"}>}sales)

use it

[#7]

create one variable for last year like

vyear=year(today())-1

if(type=Road,sum({$<ShipmentYear={"<=$(vyear)>"}>}sales))

use it

[CELAMBARASAN]

Hi,

Check with this

=Sum({<[Type]={'Road'},ShipmentYear={$(=Year(Today())-1)}>} Sales)

OR

=Sum({<[Type]={'Road'},ShipmentYear={$(=Year(AddYears(Today(),-1))}>} Sales)

Hope it helps