I want to subtract two aggregate value fields in quicksight using calculated field

image

I want to subtract
count of reciepts and filter conditons columns using calculated field both are aggregate values

I’m getting wrong values when i used sum please help
please help

1 Like

Hi,

I have an example of it. It may help you.

sum({total_bonus})-sum({Total_gross_salary})

regards,
Naveed Ali

2 Likes

How about addition of aggregate fields ?
This is showing me error for Addition and subtractions. It returns blank data.

Here is formula I have used
image

  1. calc_incurred = sum({total_res_os}) + sum({total_pay_inc_gst}) + sum({total_pay_sp_inc_gst})
    Showing error
    image

2.calc_net_result : sum({calc_net_premium})-sum({calc_incurred})
Showing blank - nothing is printing

tried without sum()
2.calc_net_result : ({calc_net_premium})-({calc_incurred})
Showing blank - nothing is printing

  1. When I print {total_res_os} : its printing $510,000.00

So If I have value in {total_res_os} why its printing blank all the calculated fields which has calculations
Anyone has idea ?
Darshana