Does anyone know why this won't work??

[samvile18]

Morning all,

I have the following syntax to count unique funds by distinct scheme, which is working fine...I can't however replicate it so it works with a sum.

=count({<FUND_Value={*}>}Distinct Distinct_ScheMemPolNo)

All I want to do is sum the total fund value by distinct scheme, any ideas anyone...it currently returns nothing, everything is blank.

[Gysbert_Wassenaar]

Try sum(FUND_Value). If you use scheme as a dimension in your chart then it will show the fund value sums per scheme value. If that's not what you want then you'll have to explain in more detail what should be the result. Preparing an example would help us find a solution for you.

[samvile18]

A simple sum should work but for some reason the totals are coming out stupidly high...I've exported the raw data to excel and the same sum shows exactly what it should.

I'm really puzzled by this one...would it matter if the field I'm trying to sum is formatted as text and not number??

[er_mohit]

Try this

sum({1<FUND_Value={'*'}>}Distinct Distinct_ScheMemPolNo)