I am trying to run reports based on a value in the sheet. I have the sheet pulling the value ${month.balance} and using an Evaluate Expression to check if ${month.balance} <= 0 and Skip if the result is True.
From debugging, I see that since the balance value is in Currency "$35.00" if might not be able to do the evaluation better. Is there a way to convert the currency to a number value before doing the expression or anyway to say:
if the balance (currency) is greater than or equal to 0, return true. or skip this row and go to the next.
I would also like to run this report monthly and each of my months is setup on Different tabs - is there anyway, once I have managed to get the expression fixed, have the report run and allow be to select which tab in the sheet I want to run it against.
Thanks