Straight Table Chart Expression update

[#1]

Good day to all and Hope all are well!!!

I have a process that I put in place for calculating YTD balances using an aggregation procedure in the Load.

Now I have, based upon account numbers, a series of calculated YTD balances that are identified as follows:

JanDepsYTDcalc, FebDepsYTDcalc, MarDepsYTDcalc, etc.

In a straight table I can simply exhibit  FebDepsYTDcalc and JanDepsYTDcalc and the difference.

I would like to drive the process using a List Box where if I select Feb, it will automatically populate the expression to perform the difference between Feb and Jan.

Please help.

Thanks,

Mitch

[sunny_talwar]

Would you be able to provide a sample of what you are trying to do?

[#3]

I have a chart (straight table) that looks like this:

Relationship Name     Account number      MayYTD Deposits    AprYTD Deposits     Diff between May and April
J&J                               23457899                  345                             310                                35

J&J                               34120943                  250                             300                               (50) 

MayYTD Deposits is derived from an aggregated calculation 'MayDepsYTDcalc'

AprYTD Deposits  is derived from an aggregated calculation 'AprDepsYTDcalc'

Diff is  'MayDepsYTDcalc' - 'AprDepsYTDcalc'

I would like to have a List Box that has all the months of the year and if I click on May then the straight table will automatically show the example that I provided.

Thank you

[Anonymous]

So you want a Month over previous month comparison starting from YTD. If so this is what we need do you have any YTD flags in your data model. If so provide us that. If not provide us your date field. stalwar1 am i referring correctly here sunny.

[#5]

I have a field called, Malpha, which contains the value 'Jan'

In my expression, I want to use Malpha  to identify the field name JanDepsYTDcalc

How would that work?

'$(Malpha)'&'DepsYTDcalc'

does not work

[boorgura]

if you are trying to arrive at the string --> $() is for evaluating variables not field.

try using only(Malpha)