Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
My requirement is to show/hide a metric column in a straight table. I wanted to hide the column if there are no values in it, otherwise show it. The column expression is:
=if(Purchase_Date - Enquiry_Date= 12, Sum( Amount), 0)
So I am trying to use the following conditional expression to show/hide that column:
=if( sum({<Purchase_Date - Enquiry_Date= {12}>} Amount) > 0, 1, 0)
But its not working, may be the problem with set analysis expression. Please could someone help how to resolve this problem, if there is a workaround without requiring to use set analysis expression thats also fine?
Thanks,
RK
Try this:
=Sum(If(Purchase_Date - Enquiry_Date = 12, Amount)) > 0
Thanks Sunny, it worked.
Just out of curiosity, is there anything wrong with this expression, just wondering why its not working:
sum({<Purchase_Date - Enquiry_Date= {12}>} Amount)
You can only have field names in the LHS of your set modifier, not allowed to do calculations of any sorts
Sum({<Purchase_Date - Enquiry_Date = {12}>} Amount)
Thanks Sunny