XFBR for Column Set
Hi all,
I'm trying to give the end-user the option to enter their forecasts in either 13 week increments (a quarter essentially) or for the full 52 weeks. This specific XFBR will determine the ...
Forum Discussion
After Dim columnname, I would create a result string, like Dim Result as String = Nothing. Then you can define the answer in your If statement.
If columnname, etc Then
Result = "S#Week01:S#Week13"
else
result = "S#Weekly.Base"
End if
Return Result
I edited my XFBR but I only get the full 52 weeks automatically, not the option of either 13 weeks or the full 52 week view column set up. Does the 'Dim Result as String = Nothing' portion of the XFBR give me back the 0.00 in the second pic?
Data Explorer Output all the way to Week52:
The Dim Result as String = Nothing just allows the rule to compile with no warning messages. Before the If coulmnname section, add brapi.ErrorLog.LogMessage(si,"ColumnName = " & columnname). after you try the Cube View again, go to the Error Log and see if it's returning the expected column name. If that looks good, try adding a log message right before Return Result and see what the system is passing back to the XFBR