hi All ,
I'm Able to achieve the difference in same column in front end , but i need to do in back end as i need to filter for Flag
Front End Expression - This is working
=if(YearMonth=min( TOTAL<ArticleNumber> YearMonth),0,
rangesum(sum( GrossListPrice) - Above( TOTAL sum(GrossListPrice))))
Back End - What am i doing wrong ?
Left Join(OneBI)
load
ArticleNumber ,
min(date(YearMonth,'YYYY-MM')) as MinYearMonth
Resident OneBI
Group by ArticleNumber;
left join (OneBI)
LOAD
GrossListPrice,
sum(GrossListPrice) as GrossListPriceMax
Resident OneBI
Group by GrossListPrice ;
ONEBI__:
LOAD *,
if(YearMonth=MinYearMonth,0,
GrossListPriceMax - Peek('GrossListPriceMax')) as Exp1
I need to Achieve this Exp1 so later i can create Flag
Please help
Advance Thanks