Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

I subtract the min(value) of Day1 with min(value) of Day2 , facing issues!

yogeshrajamani
6 - Meteoroid

I subtract the min(value) of Da12 with min(value) of Day2 ,  Generally the day 2 value is incremental of day 1 but in some cases the min value of day2 is lesser than day 1 , hence i am getting Negative value (-4555).

 

If day2 min value is lesser than day1 min value,  it should not show as negative value ! How to handle that?

 

 

2 REPLIES 2
grazitti_sapna
17 - Castor

Hi @yogeshrajamani,

 

Here is what you can do to handle the '-' sign.

 

grazitti_sapna_0-1614232148375.png

 

I hope it helps.

 

 

Sapna Gupta
danilang
19 - Altair
19 - Altair

Hi @yogeshrajamani 

 

You can also wrap the result in the ABS() function, which will remove the "-"  for negative values.

 

Dan

Labels
Top Solution Authors