I'm using Brio Intelligence 6.6
Let say I have 2 columns
1st column contain number format such as quantity unit
2nd column have pre-defined value with either H or S.
I would like to know if possible to use a formula to put a negative in front of the # in the 1st column if the 2nd column contain value H ?
Let say I have 2 columns
1st column contain number format such as quantity unit
2nd column have pre-defined value with either H or S.
I would like to know if possible to use a formula to put a negative in front of the # in the 1st column if the 2nd column contain value H ?