Good Day,
I am working on trying to create a line chart visualization that the measure formula uses a Dummy date in the set analysis. Formula takes the date selected and calculates the sales order backlog by calculating the order value for any order entered on or before that date and not invoiced by that date (all orders are loaded with a dummy date for invoice date if they have not been invoiced) formula below.
sum({$< VBAK.ERDAT = {"<$(=SELECTION_CAL.DATUM)"},VBAP.FKDAT_FUER_AUFTRAGSBESTAND = {">$(=SELECTION_CAL.DATUM_NUM)"} ,Sales={'Sales'}>} ValueEa)
What I would like to do is have a line chart with the possible date selections from the SELECTION_CAL.DATUM field as the X Axis and with the above formula so we could see the backlog value over time. However when I try to do that it displays as undefined. Any tips on what I am missing?
Load script for the date selection below.
LET vSeletionStart = num(makedate(2015,1,1));
LET vSelectionEnde = num(today());
LET vAnzahlTage = $(vSelectionEnde) - $(vSeletionStart) + 1;
SELECTION_CAL:
LOAD *,
date(SELECTION_CAL.DATUM_NUM) as SELECTION_CAL.DATUM,
year(SELECTION_CAL.DATUM_NUM) as SELECTION_CAL.JAHR
;
LOAD
recno() + $(vSeletionStart) - 1 as SELECTION_CAL.DATUM_NUM
autogenerate $(vAnzahlTage);