2 Replies Latest reply on Oct 3, 2018 9:56 PM by sooraj j

How to compare growth from one static date to current date?

Hi Friends,

I need to compare this FY 2018 starting date value with current day value then need to show the percentage of growth ?

April 1st date should be static and the value needs to check with the today's value,,

Please see the attached screen shot?

Sooraj J

• 1. Re: How to compare growth from one static date to current date?

Hi Sooraj,

Can you try this - Create 3 Calculated fields, and drag them one by one to the Text Marks Cart.

(Replace 'Order Date' field with your Date field)

1) 1st Apr 2018 Sales

IF DATEPART('year', [Order Date])=2018 AND DATEPART('month', [Order Date])=4

AND DATEPART('day', [Order Date])=1

THEN [Sales]

END

2) Curent Day Sales

IF [Order Date]={MAX(DATE([Order Date]))} THEN [Sales] END

3) % Growth     // Change the Number format to Percentage

ZN(SUM[Curent Day Sales]))/ZN(SUM([1st Apr 2018 Sales]))-1

Hope this helps.

Regards,

BKN

• 2. Re: How to compare growth from one static date to current date?

Thank You Binod