Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I currently have an expression that uses a max string function, to show the max value for a part on a specific date range, however, this does not take into account different sites. (It only takes the max value for all sites, rather than each site). Obviously, what I need is to calculate the max value for each site and then sum it.
My expressions I currently use, if helpful, are:
if(makeweekdate([BOM Chart - Timescale])-weekstart(today())<=91 AND makeweekdate([BOM Chart - Timescale])-weekstart(today())>0, maxstring([BOM Chart - FCS Sold Qty]))
maxstring({<[BOM Chart - FCS Week Date] = {"<=$(=date(only(today())+91))>=$(=date(only(today())-91))"}>} [BOM Chart - FCS Qty])
firstsortedvalue(DISTINCT aggr(min({<[BOM Chart - Date] = {"<=$(=date(only(today())+91))>=$(=date(only(today())-91))"}>} [BOM Chart - Balance]),[BOM Chart - Timescale],[BOM Chart - AutoNo]),-[BOM Chart - AutoNo])
If you could assist with my issue, it would be greatly appreciated!
Kind Regards,
Dayna
..