The version is 8.5.
This is an area that the client has to fill in and since it can be blank, I wanted to be able for them to use 0's in order to keep the formula layout 0,0,0.
It is part of much larger formula.
Thanks again,
Tiina
How to get empty spaces if the date ranges are 0
datevar range daterange3 := date(0,0,0) to date(0,0,0);
The system calculates these 0's as -
-4714-12-31.
THank you,
TIina
Ok,
Next question :)
datevar range daterange1 := date(2005,01,01) to date(2005,02,28);
datevar range daterange2 := date(2005,03,01) to date(2005,12,30);
datevar range daterange3 := date(0,0,0) to date(0,0,0);
numbervar percent := 50;
numbervar amt := 12;
Can I also create percent1, percent 2...
Sounds good,
How do you use the formulas in the body to reference the variable.
Such that would display the date range: From 2006-1-1 to 2006-4-30.
Also, how would you use the numbervar percent within the other formula to calculate.
Thank you.
Hello there,
Trying to find out how to enter data such as :
Date ranges (up to 3)
% (up to 3)
Amounts (more then 3)
That would only be changed by the client once a year, but it's used for calculating other formulas in the report.
Parameter fields have to be entered every time, is there a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.