6 Replies Latest reply on Aug 29, 2016 1:09 AM by Govind Ramchetty

current Date sum vs Previouse year sum

Dear all,

How can I compare current parameter date sum and same period last year sum.

E.g...I tired but it showing error.I know this is not syntax. Can you please help me.How can I achive.

IIF([FDate],sum(total))>IIF([LDate],sum(total))

My requirement is I have to display arrow up or down arrow. Based on current selected date vs Same period last year.

Thanks

Govind R

• 1. Re: current Date sum vs Previouse year sum

Hi Govind,

Can you please explain briefly,You want Month/Year wise for Current Year vs Last Year same period ?

Ex: Aug/2016 vs Aug/2015

Is it ?

Warm regards,

Venkata Sreekanth

• 2. Re: current Date sum vs Previouse year sum

I tried something like below

Current Year Sales:
{fixed:sum(IIF([Act Start Date]>=[From Date] and
[Act Start Date]<=[To Date],[Total],0))}

Last Year Sales:
{fixed:sum(IIF([Act Start Date]>=[Last From Date] and
[Act Start Date]<=[Last To date],[Total],0))}

Now can able to do sum.But not able to include by type .(In group by I should add Type)

Above formulae is it possible to add Type in group by class.

My result should display based on Type

E.g

Type,Current Year Sales,Last Year Sales

A---100--200

B---200---250

C---300---200

Current YEar sales and Last year sales should display based on type.How can achieve this in my above formula.

Thanks

• 3. Re: current Date sum vs Previouse year sum

When I tried it showing like below

.It should display based on Description3 types.

• 4. Re: current Date sum vs Previouse year sum

Hi Govind,
As far as i understand your problem you want to set a comparison of Value on basis of Dates.

There are two calculations i wrote to achieve this....

First to achieve the Difference

And Another to achieve the Shapes..

Please refer to the workbook attached, hope it helps.

And Please let me know if this solution helps you .

• 5. Re: current Date sum vs Previouse year sum

Thanks a lot.My requirement is different from above one.

I have 2 date parameter From Date and To date.

When I select any date e.g From date : 1 Jan 2016 To date : 31 Jan 2016 means

I have to compare same date range in previous year (from 1 Jan 2015 to 31 Jan 2015) sales.

After only I have to display above symbal (Green and Red Arrow).

• 6. Re: current Date sum vs Previouse year sum

I tied something like

But Sum(Last YEar sales) displaying total sum values instead of Descripts 3 split  1653 (1584,46,22)

Sum(Last year Sales) should

Labor1 1584

Parts1  46

Other1  22

But my query showing 1653...Can you help..