AlejandroGomez 
-
Re: How can I sum the value by list value
Hi @alexlee Try this: 1. create a new line item in your source module that checks if your "test" line item is "PY actual". If PY Actuals then Revenue else 0 2. in your target modu…1 -
Re: if formula question
Hi @Baek it seems like the first line item in your IF formula (値変更入力欄) is formatted as "number", therefore the logical test to check if is not blank should be " <> 0" …1 -
Re: How to sum a column by looking up a dimension in the module
Hi Amanda, try to do the following: 1) create a new Line Item (LI) in your module formatted as number. 2) make sure that the summary method for this new LI is SUM 2) change the dimensionality of that…2 -
Re: Lookup, Sum and Textlist Cheat Sheet
@rob_marshall thanks for pointing out that there is flip side of this and remind us that we must keep an eye the performance always! About the alternative that you propose, I would appreciate a lot i…2 -
Re: Lookup, Sum and Textlist Cheat Sheet
Hi @rob_marshall thanks a lot for taking the time to provide further explanations. I have been having a look on how could I use ANY, FirstNonBlank and the other functions as a replacement of TEXTLIST…2
