Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
mangukiyam
Contributor
Contributor

Set dynamic Waterfall Range

Hello guys,

I need your help with setting a dynamic range for the waterfall.

It should dynamic so, no need to change it every time.

mangukiyam_0-1662022788116.png

Any suggestions are welcome, Thank you 

Labels (3)
2 Replies
Mark_Little
Luminary
Luminary

Hi,

Depends on how you want to make it dynamically  change.

I tend to use If( Value 1 > Value 2, Value 2 8 * 0.95, Value 1 * 0.95)

williejacobs
Creator
Creator

Hi @mangukiyam 

Maybe try using a variable linked to a Variable Input from custom objects.

In your formula then as suggested by Mark use an If formula.