Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning. I created a calendar that shows the sales order we will need to ship everyday.
I realized that the formula for material value i created is wrong and I want to insert from this formula: Money(Sum({ $< Weekday={'Thu'}, AtHomeOrder={0}>} ExtAmt)) to this kinda fomula Money(Sum(Aggr({$< Weekday={'Fri'}, AtHomeOrder={0}>} TranAmt,TranNo))) and the problem is if I do that formula values will be the same for every day.
This the expression I currently have :
Can you someone help me?
Looks like Sum inside aggr is missing, but hope you figured out from your logic that you want to aggregate over dimensions TransAmt, TranNo field. I just corrected the syntax -
Money(Sum(Aggr(Sum({$< Weekday={'Fri'}, AtHomeOrder={0}>}ExtAmt),TranAmt,TranNo)))
Looks like Sum inside aggr is missing, but hope you figured out from your logic that you want to aggregate over dimensions TransAmt, TranNo field. I just corrected the syntax -
Money(Sum(Aggr(Sum({$< Weekday={'Fri'}, AtHomeOrder={0}>}ExtAmt),TranAmt,TranNo)))
I didn't realized the problem. Thank you for correcting me as I'm learning Qlik.