HELP WITH TOTAL VALUE

[silvia_assuncao]

Hi,

could anyone please help me on how I can have the total value here per month?

[vishsaggi]

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]) )

[sunny_talwar · Accepted solution]

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]))

[silvia_assuncao]

great guys!

it worked!

thanks