In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

logic

Ekmi9
8 - Asteroid

Error

19 REPLIES 19
mceleavey
17 - Castor
17 - Castor

Hi @Ekmi9 ,

 

Can you please provide the data, not just a screen image.

 

Thanks,

 

M.



Bulien

Ekmi9
8 - Asteroid

PFA

grazitti_sapna
17 - Castor

Hi @Ekmi9 ,

 

Interesting scenario.

You can achieve your solution by using Multi Row Formula tool for this operation. I am sharing the workflow. Hope this works for you.

 

Thanks!!

 

Sapna Gupta
Ekmi9
8 - Asteroid

@grazitti_sapna 

If you are using full data then it is not working as expected i required  FIFO logic when i can minuses  Redemption till first sub is not zero and then use the next sub. for next Redemption

 

Thanks 

mceleavey
17 - Castor
17 - Castor

Hi @Ekmi9 ,

 

this doesn't make sense, or your numbers are wrong.

Can you explain the balance on row 15?

 

M.



Bulien

Ekmi9
8 - Asteroid

Error

mceleavey
17 - Castor
17 - Castor

Do you have time to jump on a call as that doesn't make sense either. 

The first sub, last redemption, K4+K16...none of that makes sense.

 

I'm happy to jump on a call and go over the logic and see if I can help you out. DM me if you would like to jump on a Teams call.

 

M.



Bulien

Ekmi9
8 - Asteroid

Error

mceleavey
17 - Castor
17 - Castor

Ok, I think I got it.

 

 



Bulien

Labels
Top Solution Authors