0 Replies Latest reply: Mar 16, 2017 7:47 AM by Iñigo Elviro Bodoy

# VARIABLE STOPS FOLLOWING CALCULS

Hi everybody:

I hope somebody can help me in this issue.

I have a chart with 3 variables:

-vSellingsTonMonth.

-vOrdersTonMonth

-vForecastTonMonth

These variables works well in the chart, but the problem happens in the title of the chart:

='Selling ('&\$(vSellingsTonMonth)&' Ton)-Orders ('&\$(vOrdersTonMonth)&' Ton)-Forecast ('&\$(vForecastTonMonth)&' Ton)'&chr(10)&'Diference ('&\$(vSellingsTonMonth)+\$(vOrdersTonMonth)-\$(vForecastTonMonth)&' Ton)'

The formul can not calcul after the & and stops after the calcul of "vForecastTonMonth" only showing:

Selling (406 Ton)-Orders (59 Ton)-Forecast (476

When what I expect is:

Selling (406 Ton)-Orders (59 Ton)-Forecast (476 Ton)-Diference (-11 Ton)

The variable is a bit complex:

vForecastTonMonth: Floor(Sum({<MonthYear={"\$(=max([MonthYear]))"},Date={"<=\$(=max([Date]))"}>}[Forecast Ton])*

NetWorkDays(Min(Total <Date> {<MonthYear={"\$(=max([MesAño]))"},Date={"<=\$(=max([Date]))"}>} Date),Max(Total <Date> {<MonthYear={"\$(=max([MonthYear]))"},Date={"<=\$(=max([Date]))"}>} Date))/

NetWorkDays(MonthStart(Min({<MonthYear={"\$(=max([MonthYear]))"},Date={"<=\$(=max([Date]))"}>}Date)),MonthEnd (Max({<MonthYear={"\$(=max(MonthYear]))"},Date={"<=\$(=max([Date]))"}>}Date))))

It is very strange that works well alone in the chart, but with other expressions not.