Skip to Content
0

Information Design Tool parameters setting

Jul 05, 2017 at 03:58 PM

56

avatar image
Former Member

Dear All,

I would like to ask some help in setting the Information Design Tool parameters. We can give the prompt value as fix value (constant option) or also with formula Constant setting:


Szövegközi kép 2

This works perferctly.

Szövegközi kép 4
My question is that how can I resolve it with formula? How can I get this two values with formula?
The two formulas are:

Formula1: ToNumber(FormatDate(Date(Year(CurrentDate());MonthNumberOfYear(CurrentDate());1);"YYYYMM");"######") Formula2: ToNumber(FormatDate(RelativeDate(Date(Year(CurrentDate());MonthNumberOfYear(CurrentDate());1);-1;MonthPeriod);"YYYYMM");"######")

Szövegközi kép 5

Thank you in advance,
Regards, Csaba
10 |10000 characters needed characters left characters exceeded

Hi,

Can you repost the screen shots?.

Thanks,

Jothi

0
Former Member

Hi.

It's interesting. I do not know what causes this issue, I see the screenshots on my side. But I attach them once more and hopefully this time it is going to be visible on your side too.

img-1.png

img-2.png

img-3.png

Thank you.

Csaba

img-1.png (12.4 kB)
img-2.png (12.5 kB)
img-3.png (11.7 kB)
0
* Please Login or Register to Answer, Follow or Comment.

0 Answers