Back End Script Help

[kiranpatil123]

Hi All , 

I Have below Table . Need to achieve Exp1 & Exp2

Exp1 - Based on Article number where there is change in "Value " difference shud occur else 0 

Exp2 - If change in number then Need Flag TRUE or FLASE

If possible  : When User clicks on TRUE i need to show 1 previous Value in order to check how much was previous month Value 

Article no	Date	Value	Exp1	Exp2
1	18-Jan	20	0	FALSE
1	18-Feb	20	0	FALSE
1	18-Mar	20	0	FALSE
1	18-Apr	25	5	TRUE
1	18-May	25	0	FALSE
2	18-Jan	100	0	FALSE
2	18-Feb	100	0	FALSE
2	18-Mar	100	0	FALSE
2	18-Apr	104	4	TRUE
2	18-May	104	0	FALSE

Advance Thanks all

[Vegar · Accepted solution]

I gave it a try in the attached qvw. The output looks like this.

[kiranpatil123]

Cool thanks a lot it worked !!

Also thanks for quick response 🙂 

[kiranpatil123]

Hi Vegar / Partner , 

As you suggested i was trying the same thing in my real data set , its slightly different . Help me out . It is based on each Year Month peek ( Note Month Starting shud be 0 for each Article Number )

I was able to achieve in front end :

if(YearMonth=min(total <ArticleNumber> YearMonth),0,
sum(Value)- above(sum(Value))

Data below ( Want to achieve Exp1)

ArticleNumber , YearMonth ,Value , Exp1
FSR0457, 2019-03 , 0,0
FSR0457, 2019-04, 0 ,0

FSR0457,2019-05,50,50
FSR0457, 2019-06 ,80, 30
FSR0458 ,2019-03 ,0, 0
FSR0458 ,2019-04 ,0, 0
FSR0458 ,2019-05 0, 0