How to separate -ve and +ve values in straight table

[darkshadow91223]

I did a expresion to give me the difference in percentage between 2 same values to see how much it change. i want to visualize positive percentage values in one table and negative in the other one.

The expression that im using is this:

Num(1 - Sum({<TimeStamp={'Old'}>}Amount) / Sum({<TimeStamp={'New'}>}Amount), '#,###.#0%')

Any ideas?.

[devarasu07]

Hi,

you can try like below

for -ve:

if(

Num(1 - Sum({<TimeStamp={'Old'}>}Amount) / Sum({<TimeStamp={'New'}>}Amount), '#,###.#0%')<=0,

Num(1 - Sum({<TimeStamp={'Old'}>}Amount) / Sum({<TimeStamp={'New'}>}Amount), '#,###.#0%') ,0)

for +ve ;

if(

Num(1 - Sum({<TimeStamp={'Old'}>}Amount) / Sum({<TimeStamp={'New'}>}Amount), '#,###.#0%')>0,

Num(1 - Sum({<TimeStamp={'Old'}>}Amount) / Sum({<TimeStamp={'New'}>}Amount), '#,###.#0%') ,0)

Thanks,Deva

[Anil_Babu_Samineni]

You can call like this?

+ve

Num(1 - Sum({<TimeStamp={'Old'}, Amount={"=Sum({<Timestamp={'Old'}>} Amount)>0"}>}Amount) / Sum({<TimeStamp={'New'}, Amount={"=Sum({<Timestamp={'Old'}>}Amount)>0"}>}Amount), '#,###.#0%')

-ve

Num(1 - Sum({<TimeStamp={'Old'}, Amount={"=Sum({<Timestamp={'Old'}>}Amount)<0"}>}Amount) / Sum({<TimeStamp={'New'}, Amount={"=Sum({<Timestamp={'Old'}>}Amount)<0"}>}Amount), '#,###.#0%')

[OmarBenSalem]

and then under adds on; uncheck show zero values