I am totally confused.
Is there way to show missing values as Zero ('0')?
I know that these values are non-existent in this fields, but I am sure there should be a way of showin it as zeros.
I am using mastercalendar, if it matters.
This is my datamodel:
I prepared a demo for you...
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
for i= MakeDate(2018,1,1) to MakeDate(2018,3,31)
LOAD Date($(i)) as Datefield AutoGenerate 1;
LOAD *,Datefield&'|'&Operation as TEMPKEY;
LOAD *INLINE [
Datefield, Operation, Amount
2018-01-15, Sales, 500
2018-02-15, Sales, 1000
2018-03-15, Purchases, -400
//fill up Sales
Datefield, 0 as Amount, 'Sales' as Operation resident Master
where not Exists(TEMPKEY,Datefield&'|Sales');
//fill up Purchases
Datefield, 0 as Amount, 'Purchases' as Operation resident Master
where not Exists(TEMPKEY,Datefield&'|Purchases');
drop field TEMPKEY;
does not work both in the sript and in the formula
I think it won't solve the problem
because I have data missing on weekends, and therefore, it just does not record anything on weekends, so there is nothing to check for length