Using Expression for Currency

18 views
Skip to first unread message

mwsqpro...@gmail.com

unread,
Apr 18, 2015, 12:53:17 PM4/18/15
to flore...@googlegroups.com
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

Daniel Florey

unread,
Apr 20, 2015, 4:02:12 PM4/20/15
to floreysoft GmbH
Hi,
the simplest solution is to switch to number format in sheets.
If you want to keep currencies, you'll have to convert it to a number so that you expression looks like this:

Number("${month.balabce}".replace(/[^0-9\.]+/g,"")) <= 0

Regards,
Daniel

--
You received this message because you are subscribed to the Google Groups "floreysoft" group.
To unsubscribe from this group and stop receiving emails from it, send an email to floreysoft+...@googlegroups.com.
To post to this group, send email to flore...@googlegroups.com.
Visit this group at http://groups.google.com/group/floreysoft.
For more options, visit https://groups.google.com/d/optout.

MW Square

unread,
Apr 22, 2015, 10:12:19 PM4/22/15
to flore...@googlegroups.com
Hi Daniel,

Thank you for the quick response, I do have some follow-up questions:

1. I am using the load row(s) and have to select the worksheet that I want to load - is there anyway to have the worksheet to be loaded put selected from a dropdown selection at the point of execution and maybe possibly also enter the row(s) that are selected at the time of execution 

2. After I load the worksheet, I notice that it is selecting 1 column over - so it should be pulling ${month.balance}, it actually pulling the value in the column before the balance column. I have tried re-loading the worksheet and have already tried re-creating the entire ultradox

Thanks
AJ

--
You received this message because you are subscribed to a topic in the Google Groups "floreysoft" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/floreysoft/JcY5hzgggDw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to floreysoft+...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages