RE: Saved Search: Reference Other Column Value
Answered
Hi All,
I have created a saved search.
In my Result Tab. I have the following:
Field – Summary Type- Custom Label
Salary- Sum – Salaries
Bonus- Sum – Bonuses
I need to create another formula currency column called Total with the sum of the previous calculated values (salaries + bonuses) .
Is there any way to do that in the saved search or not ?
Thank you
Best answer
formula numeric or currency
sum(nvl({fieldreference},0)) + sum(nvl({fieldreference2},0))
