calculating in script

arsenal1983 — Thu, 17 Mar 2016 10:50:08 GMT

Hello,

I have such DATA in my SOURCE:

PARTNER NAME,

PERIOD (QTR),

REVENUES

REVENUES are cumulated in the year (Q1 is revenue for Q1, Q2 is revenue for Q1 and Q2 ad so on)

I need to calcuate REVENUES_QARTARLY for every single quarter - on script level.

So generaly:

if (Q1, REVENUES, REVENUES - PREVIOUS REVENUES)

The trap I identified:

1. When Partner appears first time in data:

a) if he appeard in Q1 it is easy no calculations are necessery

b) if he appeard in Q2 I need the average (REVENUES/QTR_NO)

2. When there is a drop in data

a) for period with the lack I don't want to see any REVENUES_QARTARLY

b) for period after the lack I need the average (REVENUES/QTR_NO)

Anny suggestions?,

topic calculating in script in QlikView