Mismatch aggregation error in min

Q&A
,
1

Hi,

I have a calculated field like the below named min_approved_amount

min({Approved Amount},
    [{Expense },{state},{product Size},{product Type}])

and now I want to find also the min agent. Meaning the agent that is assosiated with this min approved amount

I have tried the below but I get the mismatch aggregation error.

ifelse({min_approved_amount} = {Approved Amount}, {Agency},

NULL)
2

Hi @pantelis

You can do the following
ifelse({min_approved_amount} = min({Approved Amount}), 1, 0)

Then use the above as a filter on your visual where you have the Agent and Approved Amount and you should get the agent with the min amount show up

Regards,
Giri

3

Hi @pantelis

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

4

Hi @pantelis

Since we have not heard back from you, I’ll go ahead and archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!