KPI is not same as totals in table

[krithikarees]

The expression I used to calculate 0 days is

=sum(if ($(vClearing) and num($(vCalendarDate)) - num([Net due date]) <= 0  , [Debit/Credit Amount],0))

when I use the same expression in KPI it gives me a different total.

any help would be appreciated!

[Anonymous]

=sum(if ($(vClearing) and num($(vCalendarDate)) - num([Net due date]) <= 0 ....

this is correty and?

maybe this....

=sum(if (num($(vClearing)) = (num($(vCalendarDate)) - num([Net due date])) <= 0 .....

[jomar_ebonite]

Sample qvf would help.

Thanks

[PrashantSangle]

can you post variable definition?

Just guess I think you required aggr()

Sum(aggr(sum(if ($(vClearing) and num($(vCalendarDate)) - num([Net due date]) <= 0  , [Debit/Credit Amount],0)),YourAllDimensionIncludedInChart)).

Regards,