Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi im wondering if its possible to show only rows in a table based on the result of a table expression. I can't seem to find an answer and the good AI bots don't return any usefull answers so i turn to the good old community for answers.
I have a table which look like the picture posted below. The measures are calculated using set expressions and if statements. now i only want to show rows where diff last month is > 0 but I simply cant seems to find a usefull way.
ill post the expression for that field below, also if i add an if to the if (seems to bee abit heavy now for a simple action) it will just grey out the field but keep the row.
if(billing_date_shift < date(today()),Sum({<bill_month={'$(vPreviousMonth)'}>} bill_fee)- Sum({<bill_month={'$(vTwoMonthsAgo)'}>} bill_fee) ,Sum({<bill_month={'$(vCurrentMonth)'}>} bill_fee)- Sum({<bill_month={'$(vPreviousMonth)'}>} bill_fee))
Try this
=if(Sum({<bill_month={'$(vPreviousMonth)'}>} bill_fee)- Sum({<bill_month={'$(vTwoMonthsAgo)'}>} bill_fee) > 0, billing_date_shift)