Urgent Calculated help for LAA and Filter

Q&A
,
1

I have created a calculated field sum(max({Normalised Transaction Amount},[{aura_transaction_key}]))

which will help me remove Duplicate counting if Transaction Amount and giving accurate transactions sums

Now i Want the sum of this calculated field where Rule Execution status is True
I want to apply another filter for this Please help

2

Hi @deepa.singh
do I got it right you want to use a sumif?
BRl

3

Please help

Sun if over this field sum(max({Normalised Transaction Amount},[{aura_transaction_key}])

4

Try this:

sum(
	max(
		ifelse(
			{Rule Execution status} = 'True', {Normalised Transaction Amount},
			null
		),
		[{aura_transaction_key}]
	)
)
1 Like
5

You are awesome thank you so much