4 Replies Latest reply on Jan 22, 2018 2:42 AM by Niranjan Banarjee

# Calculation help

Hi,

I am trying to segregate manufacturer level data for which i used the below formula and is giving me correct result aggregating entire time period:

{ FIXED [Country Display],[Calendar Period],[Modality Display],[Channel Display] :sum((IF [Manufacturer-China[Top-6]]] = [Select Manufacturer] THEN [Measurements] else 0 END))}

But, If I try to only consider YTD 2017 with the help of below formula:

(IF DATEDIFF('year',[Calendar Period],[Ending Date])=0 AND MONTH([Calendar Period])<=MONTH([Ending Date]) THEN [Aggregate Manufacturer Data]END)

• ###### 1. Re: Calculation help

Hi Niranjan,

Could you share a workbook in .tbwx format?

Regards,

Norbert

• ###### 2. Re: Calculation help

Hi Norbert,

I got the YTD Claculation, but the problem is if I use the formula of Growth simply as (YTD-Current Year)/(YTD-Previous Year)-1. It is giving me wrong out put.

It seems it s giving me the Sum of growth numbers as granular level.

Should I use any other formula for growth calculation using ZN or ATTR?

• ###### 3. Re: Calculation help

Hi Niranjan

I am assuming this is related to the same report in your other question

Manufacturer-YTD=

{FIXED [Manufacturer-China[Top-6]]],[Country Display],[Calendar Period],[Modality Display],[Channel Display]
:sum((IF [Manufacturer-China[Top-6]]] = [Select Manufacturer]
and DATEDIFF('year',[Calendar Period],[Ending Date])=0 AND MONTH([Calendar Period])<=MONTH([Ending Date])