Forum Discussion
Data validation?
I don't know if I'm using the correct terminology for this, but I'll give an example. I have 3 conditional columns that provide a value based on the value of another column. However, the end user has...
Hi swebb
This sounds possible but I'm confused by the description, for example if Quoted not null or 0, use Quoted which Quoted column are you referring to?
It would be easier to offer a solution if you provided some sample data so I can see the table structure.
Regards
Phil
So, here's an example of what should happen:
Essentially if both quoted and estimated are used, only use one or the other, in all cases, the actual quoted should be used, not estimated. If all amounts are estimated amounts, use those, if all are quoted, used quoted, if a mix, use only quoted.