Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Cool thanks a lot it worked !!
Also thanks for quick response 🙂
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