Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm having problem how to get Total in expression for 'Achievement'. : -
Column 1 : December
sum({$<[Date Disbursed - Month]={'$(=max([Date Disbursed - Month]))'}>} [ETP Amount]))
Column 2 : Achievement
column (1) /
if(index([Make Segment II],'New Nation')>0,120000000,
if(index([Make Segment II],'New Foreig')>0,120000000,
if(index([Make Segment II],'Used')>0,120000000,
if(index([Make Segment II],'Recondi')>0,40000000,
if(index([Make Segment II],'Other')>0,0,
if(index([Make Segment II],'Enterpr')>0,0,0))))))
Expected Result
Actual Result:
Ok so as I suggested, if you change the total mode it works, you need to tell us what output you're expecting here
Hi gysbert,
Thanks for your comment. You giving me an idea.
I got the answer... the achievement should be write as below:
column (1) /
if(index([Make Segment II],'New Nation')>0,120000000,
if(index([Make Segment II],'New Foreig')>0,120000000,
if(index([Make Segment II],'Used')>0,120000000,
if(index([Make Segment II],'Recondi')>0,40000000,
if(index([Make Segment II],'Other')>0,0,0))))))
(120000000+120000000+120000000+40000000) // Amount targetted only
Thanks Adam,
I got it. I Change 'else' value with a value as below
column (1)
/
if(index([Make Segment II],'New Nation')>0,120000000,
if(index([Make Segment II],'New Foreig')>0,120000000,
if(index([Make Segment II],'Used')>0,120000000,
if(index([Make Segment II],'Recondi')>0,40000000,
if(index([Make Segment II],'Other')>0,0,if(index([Make Segment II],'Enterpr')>0,0,120000000+120000000+120000000+40000000))))))