Expression total error in getting delta

[#1]

Expense

$192,577

($163,772)

Here ($163,772) is _ve value and when I give expression total in a straight table I get $356,349 which is wrong.I have to get the delta of  28,805.How can I achieve that ?

Thanks much

[sunny_talwar · Accepted solution]

Try 'Sum of Rows' as total mode. If that doesn't work still, would you be able to share a sample?

[amayuresh]

Can you post sample data ?

Because it work for me in normal scenario,

Script:

LOAD * INLINE [

    Category, Item, Supplier, Data

    Cat1, Item11, Sup2, 100

    Cat1, Item11, Sup3, -150

    Cat1, Item12, Sup1, 200

    Cat1, Item12, Sup2, 1

    Cat1, Item12, Sup3, 1

    Cat1, Item12, Sup4, 1

    Cat2, Item21, Sup2, 1

    Cat2, Item21, Sup3, 1

    Cat2, Item21, Sup4, 1

    Cat3, Item31, Sup1, 1

    Cat3, Item31, Sup2, 1

    Cat3, Item31, Sup3, 1

    Cat3, Item31, Sup4, 1

    Cat3, Item32, Sup1, 1

    Cat3, Item32, Sup4, 1

];

Output:

[tyagishaila]

share sample data...

how you consider ($163,772) as -ve.

if your

Expense

$192,577

-$163,772

than you will definitely get  correct total/Sum.

[avinashelite]

Try like this

if(wildmatch(Expense,'(*)')>0,purgechar(Expense,'()')*-1,Expense)

[Anonymous]

Once export your chart to excel and check .share your sample data