sum

[raadwiptec]

iam trying to get the total for this expression.. but getting 0 values

Sum({<$(='[Invoice_T]')={'SPO'}>}$(='[Expense Amount'&[Invoice Type]&' | '&[Rates]&']'))

i tried below but get 0 values

Sum({TOTAL<$(='[Invoice_T]')={'SPO'}>}$(='[Expense Amount'&[Invoice Type]&' | '&[Rates]&']'))

[sunny_talwar]

Would you be able to share a sample?

[raadwiptec]

i do not have sample.. it s a very big file..

Sum({<$(='[Invoice_T]')={'SPO'}>}$(='[Expense Amount'&[Invoice Type]&' | '&[Rates]&']')) -this part works and iam using it sometimes..

now i need total

[Anonymous]

Are these fields are in different tables  Expense Amount , Invoice Type ,  Rates ?

try this

Sum({<$([Invoice_T])={'SPO'}>} $(='[Expense Amount'&[Invoice Type]&' | '&[Rates]&']'))

[raadwiptec]

hi allu wer is total here

[Anonymous]

so you want sum of Expense Amount , Invoice Type ,  Rates fields when    Invoice_T = SPO ?

[raadwiptec]

i already have the sum but i need the full total now

[Anonymous]

I am not sure about this ,

Remove  $

Sum({<([Invoice_T])={'SPO'}>} $(='[Expense Amount'&[Invoice Type]&' | '&[Rates]&']'))

or

Sum( Total {<([Invoice_T])={'SPO'}>} $(='[Expense Amount'&[Invoice Type]&' | '&[Rates]&']'))

I think you better work with aggr() functions for this