Add Cost in the last Month

[qlikwiz123]

I have Price Per Month being calculated in the QVW. 

How do I add $100 in the last month of every ID? For instance,  ID 2, for 5/1/2020, I need to add $100 to PricePerMonth and show it as $110

[tresesco]

Assuming you are looking for a UI solution, try like:

If(Month=Max(total <ID>Month), Sum(PricePerMonth)+100,Sum(PricePerMonth))

[rubenmarin · Accepted solution]

Hi, it may be different based on what dimensions the table will have.

In example, for a table with Id and Month as dimensions: If(Month=Max(TOTAL <ID> Month), PricePerMonth+100, PricePerMonth).

In a table with only ID as dimensiones this expression is possible: Max(Aggr(If(Month=Max(TOTAL <ID> Month), PricePerMonth+100, PricePerMonth), ID, Month))

[qlikwiz123]

@rubenmarin @tresesco 

Thank you so much