Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a table like this:
FLAG AMOUNT QUOTE PERCENTAGE PRICE -> if(flag='YES', sum(amount*percentage)/100, quote)
YES 10 5 0 5
NO 15 0 3% 0,45
NO 30 0 5% 1,5
How can I show a KPI with the total price?
Try something like
Sum(Aggr(if(flag='YES', sum(amount*percentage)/100, sum(quote)),flag))