Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Use previous value that is not blank

Hi there,

 

I have tthree tables in my model:

Finance_Version with the version and the order of each version:

 

Another table with projects information and other with financial information where we extract the total amount of combination of Finance_Version + Project.

 

If I combine the three tables in one general visualization table I obtain something like that:

 

Now I want to have replace the 0,00 and blank values for the last valid value. For example, for project ESBD102, as the last valid value is in F2, I would like for F3 until F11 the value 1.027.373,41 € and in case that we have a new value for F5, then F2, F3, F4 will continue with 1.027.373,41 €  and from F5 to F11 will be populated with the new value in F5.

 

Is posible to create a meaure or new column with that?

 

Thanks in advance!

Juanjo

8 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion

    measure =
    IF ( ISBLANK ( fieldname )0, fieldname )

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Vanessa,

       

      Thanks, but it doesn't solve the issue. It just put the value if it is not blank or 0 if it is blank.

       

      • vanessafvg's avatar
        vanessafvg
        Icon for Community Champion rankCommunity Champion

        Anonymous  ah right apologies i understand, are you able to share the file?  or some data?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

     

    Any idea?

     

    Thanks,

    Juanjo

    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion

      Anonymous  hi apologies, ive been away will look at it sometime today

    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion

      Anonymous  sorry taking longer than expected, struggling a bit but will keep trying..   not a simple problem to solve, if anyone wants to chip in feel free..

      • Anonymous's avatar
        Anonymous
        Not applicable

        Thanks Vanessa.

         

        Hope someone can help in this issue.

         

        BR,

        Juanjo