PS Query - convert negative values to zero
Hello! I'm hoping this is a relatively simple question for your Query experts. I am trying to set up an Excel to CI for our Total Rewards Statements that include leave balances and the value of those balances. Some employees' balances go into the negative, which we don't want to show. If an employee has a negative balance, we want to show that they have a zero balance instead. Is this possible in Query rather than manipulating the Excel data once we send it there?
Thanks very much!