Information Design Tool parameters setting

[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:

This works perferctly.


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");"######")



Thank you in advance,
Regards, Csaba

[jyothirmayee_s]

Hi,

Can you repost the screen shots?.

Thanks,

Jothi

[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

[mhmohammed]

Hi Csaba,

In the img-1, please use the Formula option (instead of Constant) and paste the below formula in there

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

Try that and let us know.

Thanks,
Mahboob Mohammed