Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have this expression
if($(VandL)='Profit',
Fabs(sum({<Flag={'14'},Update_Date={$(vMaxDate)},
[AccCapt]=,[AccCate]=,[AccsubCat]=,[AccDesc]=>}[LBalance]))
,
if($(VandL)='Return',
Fabs(sum({<Flag={'17'},Update_Date={$(vMaxDate)},[AccCap]=,[AccCat]=,[AccSubCat]=,[AccDesc]=>}[LBalance]))
,
if($(VandL)='Net',
(Column(14)-Column(17))
i tried to minus but this not show result what should i do problem is in this
if($(VandL)='Net',
(Column(14)-Column(17))
Hi Amber, can u please explain your question at high level or at business level that makes some sense.
What column(14) and column(17) returning?