Null value handling

[vinod_r]

I have requirement of calculating Previous Year revenue with current year FX Please see attachments for Problem and Reuired Solution

- Final Amount should be converted into EUR with latest Year FX

- All selection combination must be possible after calculation

Looking forward for solution 🙂

[MayilVahanan]

Hi @vinod_r 

One of the way to achieve the result.. Please verify

[vinod_r]

Thanks MayilVahanan,

But that doesn't full fill the condition of "Should be able to filter all values in the Mulitibox shown in the app " . Region Code 8235 is not selectable in your solution

Regards

vinod_r

[MayilVahanan · Accepted solution]

HI @vinod_r 

Its not in source itself. 

If you want to generate the missed data,  try like attachment, it will generate all missed info from txn table.

[vinod_r · Accepted solution]

Got it..!!!

Thanks a lot @MayilVahanan