IFELSE (Conditional multiple how to treat)

Q&A
, ,
1

Hi team, I am new to quicksight and I need help for this request:
I am creating a field calculated with multiple conditionals to basically calculate the cost of the product with filters by country, currency, payment method with IFelse function but the error formula because it says that it has aggregated fields with unaggregated fields. Can you help me fix this problem?

ifelse(
min({opc_fee}) = 0, – main condition
{Average price_usd} * min({opc_fee_percentage}) + ifelse( – Beginning of the main true value
{opc_fixed_fee_currency} = ‘USD’, – Condition of the nested ifelse
min({opc_fixed_fee}), – True value of the nested
min({opc_fixed_fee}) / min({opc_fx_rate_percentage}) – Value of the false nested
), – End of the main value
0 – False value of the main ifelse
)

2

Hi @jcolucci ,

the following fields are not aggregated IN the calculation, please check if they are aggregated calculated fields (eg. SUM, MIN, MAX, ..):

{Average price_usd}
{opc_fixed_fee_currency}

Maybe this article can help you:

It shows a list of alternatives.

Best regards,
Nico

3

Hi @jcolucci,

Looking at the formula it appears you have a mix of fields that are aggregated and others that are not.

You should review the following article to understand the level awareness and then tweak your calculated field accordingly.

Regards,
Giri

4

Hello Giridhar, thank you for the information but I still could not solve the problem and need help.

I made this formula and would like your help to correct it because the system does not work. Can you please help me? Thank you! ifelse(min({opc_fee}) = 0, min({opc_fee_percentage}) * min({Average price_usd}) + ifelse( {opc_fixed_fee_currency} = ‘USD’, min({opc_fixed_fee}), ifelse(min({opc_fx_rate_percentage}) = 0 OR isNull(min({opc_fx_rate_percentage})), 0, min({opc_fixed_fee}) / min({opc_fx_rate_percentage}))), 0)

5

Hi @jcolucci

Can you upload your case to Quick Sight Arena so I can take a look ?

Regards,
Giri

6

Hi Nico, good afternoon!
I don’t have access to Quick Sight Arena.

7

Hi @jcolucci

You can refer to the the Getting Stared Page of Arena to understand the process to sign in the Arena

image
image535×319 20.1 KB

Regards,
Giri

8

Hi @jcolucci

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!

9

Hi @jcolucci

Since we have not heard back from you, I’ll go ahead and close/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!