Update Value with Formula
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I am getting a parse error when I am trying to update this formula (\2017\03-March\VALIDATE CASH 03-31-2017.xlsm) into Alteryx Action tool- see formula below.
"\"+tostring([#1])+"\"+tostring([#2])+"\VALIDATE CASH "IF +tostring([#3])+ = ‘Q1’ THEN ‘03-31’ ELSEIF +tostring([#3])+ = ‘Q2’ THEN ‘06-30’ ELSE ‘ERROR’ ENDIF"-"+tostring([#1])+".xlsm|CMLReinsured $"
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That worked, thank you so much!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Even more complicated, getting an invalid type in subtration operator
"\\mmdata3b3r\REINS\Palm\"
+ IF tostring([#2]) = "Q1" THEN tostring([#1])-1 ELSE tostring([#1]) ENDIF +
"\"
+ IF tostring([#2]) = "Q1" THEN "12-December" ELSEIF tostring([#2]) = "Q2" THEN "03-March" ELSEIF tostring([#2]) = "Q3" THEN "06-June" ELSEIF tostring([#2]) = "Q4" THEN "09-September" ELSE "ERROR" ENDIF + "
\WiltonRe Reserves_"
+ IF tostring([#2]) = "Q1" THEN "Dec" ELSEIF tostring([#2]) = "Q2" THEN "Mar" ELSEIF tostring([#2]) = "Q3" THEN "Jun" ELSEIF tostring([#2]) = "Q4" THEN "Sep" ELSE "ERROR" ENDIF + "
+ IF tostring([#2]) = "Q1" THEN Right([tostring([#1])-1],2) ELSE Right([tostring([#1])],2) ENDIF +"
.xlsx"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What are the "-1" operations you are attempting? What are some potential values of [#1] and [#2]?
"\\mmdata3b3r\REINS\Palm\"+
IF tostring([#2]) = "Q1" THEN tostring(ToNumber([#1])-1)
ELSE tostring([#1]) ENDIF +
"\"+
IF tostring([#2]) = "Q1" THEN "12-December"
ELSEIF tostring([#2]) = "Q2" THEN "03-March"
ELSEIF tostring([#2]) = "Q3" THEN "06-June"
ELSEIF tostring([#2]) = "Q4" THEN "09-September"
ELSE "ERROR" ENDIF +
"\WiltonRe Reserves_"+
IF tostring([#2]) = "Q1" THEN "Dec"
ELSEIF tostring([#2]) = "Q2" THEN "Mar"
ELSEIF tostring([#2]) = "Q3" THEN "Jun"
ELSEIF tostring([#2]) = "Q4" THEN "Sep"
ELSE "ERROR" ENDIF +
IF tostring([#2]) = "Q1" THEN Right(tostring(ToNumber([#1])-1),2)
ELSE Right(tostring([#1]),2) ENDIF +
".xlsx"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In the first IF statement I am trying to take a year for example 2017 and minus one for PY.
In the third statement I am trying to take the year so it is 17 or 16.
![](/skins/images/0052A40480681DBBC707042CBFDD66A8/responsive_peak/images/icon_anonymous_message.png)
- « Previous
-
- 1
- 2
- Next »