removal of negative accumulation

[Anonymous]

Hi guys ,

               i created one line chart in that accumulation is there. i want to show only positive accumulation , is there any way by which i can remove negative line or transparent that. as due to that other information is hiding. Please refer attach files.

[AbhijitBansode]

use RangeMax function to neglect negative values.

eg. RangeMax(Sum(Sales),0)

[Anonymous]

yes it help but not solving issue fully

i want - where accumulated value is negative than there 0 should come or no line for that

while by range max, previous value is coming or no accumulation happen for that.

Business wants - only gaps (where actual sales < budget\target sales)

no lines when actual > target as there is no gap..

can you help

[AbhijitBansode]

RangeMax(Sum(Sales),0)

Above syntax will return zero when sum(Sales) is negative and thus negative value will not interfare with the calculation of chart.

[Anonymous]

please check attachment

in that for FY15 - gap is coming (8,13,13,13) when using RangeMax

while i want answer as (8,13,2,0) as gap(Target - Actual)