values not populating

[Anonymous]

dear all,

I have  a data like shown below. that data is for 24 months which shows claims and settled claims. but the problem is , for settled I am getting total value at the 24 month, rest is showin zero. my requirement is it should populate data for each month

how to do it?

I

[sagarkharpude]

can you share the data.

[PrashantSangle]

What was the logic to calculate settle???

Is there any field available in your source to identify settled value for year?

provide more details

Regards

[stonecold111]

Populate means...  What data it should populate... what is the expression you are using for settled??

[Anonymous]

heres d logic:

(ROUND(Sum({<[Common Sales Date]={">=$(=vCommonMinDate)<=$(=vCommonMaxDate)"},MIS={"$(v_MIS_Range_Max)"}>} [Sales Quantity])))

//v_Mis_range_max =if(GetSelectedCount(MIS)=0,24, max(MIS))

// MIS is months

[stonecold111]

when there are no selections made, it will just display only for MIS=36. that's y it is not populating data.

try to remove that and see or else

just use     [Sales Quantity]

[stonecold111]

sorry MIS=24

[stonecold111]

(ROUND(Sum({<[Common Sales Date]={">=$(=vCommonMinDate)<=$(=vCommonMaxDate)"}>}[Sales Quantity]))

Use this

[stonecold111]

round([Saes Quantity]) is the best option