Adding two new calculated dimensions in a (straight) table

[Anonymous]

Hello Everyone,

Hope someone can help me with my challenges.

I have a straight table shown below, using this table I would like to add two new calculated dimensions (1) # of days aging (2) Pass/Fail.

Hope someone can guide me if it is possible to add those using LOAD or in Expressions?

This would be the logic:

1. # of days aging

if ("Case Number" is equals,  if ( "PSR or RMA Transaction" = 'RMA' = 0, Otherwise (PSR),

(RMA&CreatedDate - PSR&CreatedDate)

I have attached an excel file as a reference for this logic.

2. Pass/Fail - If <=1, Passed, Failed

Appreciate any inputs there may be.

Thank you in advance!

IC