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
)
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)
