Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to insert a chart on my 'Amount' column where I only want to sum rows where 'Source' = 'REVENUE'. The 'Source' field contains 'REVENUE', 'COSTS', and 'BUDGET', but I only want the chart to include the Revenue rows. Can someone provide syntax for the expression?
Many thanks!
Sum(IF(Source='Revenue,1,0)*amount) should be working.
using set analysis:
Sum({<Source={'REVENUE'}>} Amount}