Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
could anyone please help me on how I can have the total value here per month?
Like this?
Expression:
Sum(Aggr(If(left([Unique Resource ID],1)=1
or left([Unique Resource ID],1)=2
or left([Unique Resource ID],1)=3
or left([Unique Resource ID],1)=4
or left([Unique Resource ID],1)=5
or left([Unique Resource ID],1)=6
or left([Unique Resource ID],1)=7
or left([Unique Resource ID],1)=8
or left([Unique Resource ID],1)=9
,Sum([Distribution Value])/([Resources Quantity])), [Unique Resource ID], [Reference Month]))
or this:
Sum(Aggr(If(Match(Left([Unique Resource ID], 1), 1, 2, 3, 4, 5, 6, 7, 8, 9),
Sum([Distribution Value])/([Resources Quantity])), [Unique Resource ID], [Reference Month]))
What is the TotalValue you are expecting here ?
Something like this ?
Change the expression to this and see if this is what you are looking for :
= Pick(Match(left([Unique Resource ID],1), 1 ,2, 3, 4, 5, 6, 7, 8, 9), Sum([Distribution Value])/ Sum(Total [Resources Quantity]) )
Like this?
Expression:
Sum(Aggr(If(left([Unique Resource ID],1)=1
or left([Unique Resource ID],1)=2
or left([Unique Resource ID],1)=3
or left([Unique Resource ID],1)=4
or left([Unique Resource ID],1)=5
or left([Unique Resource ID],1)=6
or left([Unique Resource ID],1)=7
or left([Unique Resource ID],1)=8
or left([Unique Resource ID],1)=9
,Sum([Distribution Value])/([Resources Quantity])), [Unique Resource ID], [Reference Month]))
or this:
Sum(Aggr(If(Match(Left([Unique Resource ID], 1), 1, 2, 3, 4, 5, 6, 7, 8, 9),
Sum([Distribution Value])/([Resources Quantity])), [Unique Resource ID], [Reference Month]))
great guys!
it worked!
thanks