help ! needed in creating a formula

[fashid]

Hi,

I am stuck with  a formula to create

The formula is conversion efficiency:-

=sum({<[MARA.Material Type_MTART]={'HALB'}>}[VEKP.Loading volume_NTVOL])/50832*100

the Problem is that if the user selects 3 days, the denominator should get multiplied by 3, the same should happen if the user just selects a single month then the denominator should get multiplied by 30 or 31 depending on the month in the master calendar.

How do i go about doing this

Thanks & regards,

Nadeem

[Anonymous]

Hi ,

You better create a aditional static column repeated for each row in calendar table.

like 1 as addtional column in script. Afte that you use the sane column in denominator. Just take the sum/count of that column. if you select a month, it will take count for possible numbers.

this should do.

just

Regards,

Chinna

[marcus_sommer · Accepted solution]

Try: YourExpression / count(distinct date)

- Marcus

[fashid]

Thanks a lot , without you guys it would be just so difficult 

[fashid]

Thank you for taking out your time to reply