Forum Discussion

Mons_Aku's avatar
Mons_Aku
New Member
3 years ago

How can I change values in a calculated column?

Hi! I have a calculated column "Days To Ship" (a product) with data type "Whole number".  Some values here are incorrect for example -34568. Every value has to be at least 1. I want to create a Gaug...
Need Help
Mons_Aku's avatar
Mons_Aku
New Member
3 years ago

For my calculated column?

DaysToShip = Orders[ShippedDate] - Orders[OrderDate]
 

You can see the incorrect values above.

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Mons_Aku 

try like,

DaysToShip = 
VAR _value =
Orders[ShippedDate] - Orders[OrderDate]
RETURN
IF(_value<1, 1, _value)
  • Akuhei05's avatar
    Akuhei05
    New Member
    3 years ago

    That was it! Thank you!