I need to create a formula for a parameter in which whatever the value user enters it should return a value in multiplication of 250.for example if the user enters 150 it should return 250 if user enters 600 it should return 750. Any idea on this?
Gelöst! Gehe zur Lösung
Gelöst von barthbradley. Gehe zur Lösung
Gelöst von TripleM-Dev.net. Gehe zur Lösung
Hi,
Use 2 parameters, a input parameter and a converted parameter and use the function Round / RoundUp / RoundDown.
See samples below, depending on rounding demand use any of the 3 rounding functions.
(looks like you need Roundup, 0=250, 600=750 etc)
For this example I used Integers, but could be used with any number units.
Round, RoundUp, RoundDown
- Michel
@msdvicky wrote:I need to create a formula for a parameter in which whatever the value user enters it should return a value in multiplication of 250.for example if the user enters 150 it should return 250 if user enters 600 it should return 750. Any idea on this?
Preparing client invoices?
![]()
..if so, whatever you do, don't put a stamp on the envelope and mail the invoice.
If there is one thing I learned from watching the movie "The Firm"; the stamp is what makes the False Invoice a Federal Crime - not the False Invoice itself.
FWIW
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.