Granularity of data, different Value SHowing

[ivandrago]

Hi,

I have the attached document, I want my text box to show a certain figure but due to the granularity of the data I am unable to get this.

Any ideas?

Thanks

[swuehl]

Could you describe a bit closer how you calculated

302930.76

?

[alexandros17]

Use this value in your text box

='Value'&chr(10)&chr(10)&sum(Aggr(DISTINCT #UnallocatedAmount, %PK))

let me know

[Clever_Anjos · Accepted solution]

Please try

='Value'&chr(10)&chr(10)&sum(aggr(only(#UnallocatedAmount),%PK))

[sunny_talwar]

My bad, I didn't realize this was already mentioned

[swuehl]

Maybe another option without the need for advanced aggregation:

=Rangesum(

     Sum(#LineValue),

     Sum( {<Product = {'NOT APPLICABLE'}>} #UnallocatedAmount)

)