KPI

[Prithika]

HELLO

Is there any expression that sums only negative value or only positive values?

i have a dataset in which the expanse of the company is in negative value and income is in positive value. i need to show only expanse value in one kpi and income value in one kpi is it possible.

[vikasmahajan]

Hi ,

You can take only positive values like :

Sum({< Value = {">0"} >} Value)

This is sum only positive numbers only.

Thanks

Vikas