766
Hi-
I have never tried to use an IF Formula in MR, so I am not sure if it is possible. I used the Excel logic (see below), but it doesn't like the "=".
Does the formula option allow IF statements?
*This post is locked for comments
That's a neat little workaround. Too bad it won't export out to Excel.
Hi Matt-
Just wanted to share what I have learned:
This is what we were able to accomplish with populating "TEXT". However, if exporting to Excel, the values populate at 0 and the text is lost. Also, the non text fields show up as "1".
Below is the formula and the over-ride screen shot.
IF L<-.1 THEN 0 ELSE IF K <-9999 THEN 0 ELSE 1
For my particular situation, I work these reports into Excel. I just used the standard formula, and assigned 1 and 0 to the different values, so I could populate the TEXT in an excel macro via Find/Replace.
Just wanted to share!
HI Matt!
I tried this formula, but I must be missing something. I am not too familiar with IF Statements in Excel either, that might be part of my issue. This is what I am trying to mock. =IF(F7=0," ",I7/F7)
|
IF G=0 THEN G ELSE K/G IF G=0 THEN K/G |
I tried this formula, but it wants me to replace Reason with ELSE. So I don't think the text portion will work.
IF L<.01 THEN PROVIDE REASONS AND ACTION PLAN, IF K<-9999.99 THEN PROVIDE REASON AND ACTION PLAN
I may need to setup a macro to set these formulas after export, but just thought I would see if I could skip that piece. :)
Yes, you can definitely do If statements in MR. No = sign in front. An example would be: IF B>100 THEN B ELSE C*1.25
However, I am not sure if you can put text in a number field like you are trying to do. I'll be interested to hear if that actually works.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
