John

Hi! Regarding the Over Function, is it possible to do division on below two expressions to get the rate? 1st Expression/2nd Expression 1st Expression: SN(Sum([FGOUT]) / Count([FGOUT]),0) + SN(Sum([New_Early]),0) - SN(Sum([New_Backlog]),0) - SN(Sum([New_Commit Qty]),0) THEN sum([Value]) OVER (AllPrevious([Axis.Columns])) as [Delta] 2nd Expression: Sum(-[New_Commit Qty]) as [Commit]

HI Oliver, Yes it works!. Thanks!

Hi David, I already rename the [Delta] and I still facing the same error. I did try to remove the 4th expression and it's working. can we use two THEN statements in an expression?

This column suddenly turned red when applying a THEN on previous expression.

im having an error when i try ti copy your expression. can help?

Hi! Would it be possible to add multiple cumulative sum expressions? I want to get the delta of the following expression 1st Expression: SN(Sum([New_Backlog]) OVER (AllPrevious([Axis.Columns])),0) 2nd Expression: SN(Sum([New_Early]) OVER (AllPrevious([Axis.Columns])),0) 3rd Expression: Sum([New_Commit Qty]) Then Sum([Value]) OVER (AllPrevious([Axis.Columns])) as [Cumm Commit] 4th Expression: Sum([FGOUT])/Count([ExtractDate]) THEN Sum([Value]) OVER (AllPrevious([Axis.Columns])) as [Cumm Out] Delta Forumul 3rd Expression + 2nd Expression - 1st Expression - 4th Expression

Is ther a way how i can pass the value of listbox to a table to use as a dropdown value or listbox. thanks!

Hi @Ahmad Fattahi, not yet...

Any idea how to search specific strings inside a multiple text file and then convert this into a table?? Sample Output File name | String 1 | String 2 | String 3 | String 4 A.txt | A.1 | A.2 | A.3 | A.4 B.txt | B.1 | B.2 | B.3 | B.4

ok will do. thanks for notifying me..

Any idea how to search specific strings inside a multiple text file and then convert this into a table?? File name | String 1 | String 2 | String 3 | String 4 A.txt | A.1 | A.2 | A.3 | A.4 B.txt | B.1 | B.2 | B.3 | B.4

Thanks David, Yes i will try this..

Thanks Gaia! Let me try this :)

Can this function on a local table? Is it capable of analyzing the content and the visualizations?

Hello there! a newbie here, just want to ask how to create a function that can read a multiple text file (searching specific text or group of strings) and then convert this into a table. Sample Filename | Search String1 | Search String2 | Search String3 |