Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
use RangeMax function to neglect negative values.
eg. RangeMax(Sum(Sales),0)
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
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.
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)